Array data type not supported on trial

[former_member394623]

Hello:

I'm using the Hana free trial and I've set it up to run on an Microsoft Azure Virtual Machine.

I'm using ODBC to connect and I'm trying to create a table with an ARRAY data type and I'm getting the following message that it is not supported.  I'm new to Hana so I'm wondering if ARRAYS are a new feature or if they are just disabled on the trial?  Is there any way to enable this feature on the trial?  Thanks for the help!

CREATE TABLE ARRAY10_tbl

(col1 integer

,col2 integer ARRAY(10));

ERROR [S1000] [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;7 feature not supported: cannot create row table having array type: COL2

[former_member394623 · Accepted solution]

By creating this as a COLUMN TABLE I was able to create this array.