.NET USING SAP HANA DB REAL_VECTOR

[agey76]

Hello,

when i create a table with .NET i get the error: "sql syntax error: incorrect syntax near "REAL_VECTOR": line 1 col 50 (at pos 50)'"

I think i have the newest version of libadonet.dll (2.20.22.39682).

Here my example code:

var connection = new HanaConnection(_connectionString);
connection.Open();

var command = new HanaCommand($"CREATE COLUMN TABLE VECTORTAB (ID NVARCHAR, DATA REAL_VECTOR);", connection);
command.ExecuteNonQuery();

connection.Close();

Is it not possible to use the new Datatype REAL_VECTOR?

Greetings,
Andreas

[agey76]

I have updated to the newest version 2.20.23, but same error.

[thomas_mller13]

Vector DB is only existing in HANA Cloud version. So this data type will probably also only exist there. What do you have?

[agey76]

I have SAP Hana Cloud...

[agey76]

The problem was solved by updating the SAP HANA DB 2024.2.17.