on 07-16-2013 3:32 PM
Hi all ,
Following code written to define table .....
table.schemaName = "MYSCHEMA";
table.tableType = COLUMSTORE;
table.description = "table Description";
table.columns= [
{name ="Col1"sqlType =NVARCHAR;nullable = false;length =15 comment = "OrderId";},
{name ="Col2"sqlType =NVARCHAR;nullable = false;length =20 comment = "Order Item";},
{name ="Col3"sqlType =DECIMAL;nullable = false;precision =15;scale =3; comment = "Quantity";},
{name ="Col4"sqlType =NVARCHAR;nullable = false;length = 3; comment = "Quantity unit";}];
table.primarykey.pkcolummns=["Col1","Col2"];
Giving me following error
ERROR workshop/sessiona/00/data/MYTABLE.hdbtable
Repository: CheckObjects failed for at least one object; Parse error for table definition: Syntax error in line 0 and column 0 : unknown name
Please let me know where is bug in my code .
hari
Hi Hari,
As Basha mentioned:
table.tableType = COLUMNSTORE;
In
table.columns - you have missed semicolons in defining column fields, it should be as:
{name = "Col1"; sqlType = NVARCHAR; nullable = false; length = 15; comment = "dummy comment";},
Similarly, correct Col2, Col3 and Col4 lines also
Rest is fine.
For further details, you can refer to HANA Developer Guide:
http://help.sap.com/hana/SAP_HANA_Developer_Guide_en.pdf
Regards,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Basha and vivek,
Thank you very much .
I got it now.
regards.
hari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hari,
Please check the below syntax.I think it should be COLUMNSTORE.
table.tableType = COLUMSTORE;
Thanks
Basha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.