on 04-01-2021 5:17 PM
We have an XSA database with some hdb artifacts created and deployed using SAP Web IDE. Now we are migrating to HANA Cloud. I created a HANA Database Project from template in BAS and imported hdbtable files exported from the old database. When trying to deploy, BAS complains about incorrect SQL syntax near any statements using column store types.
Ex:
ROW TABLE "COUNTRIES"(
"CODE" CHAR(2) CS_FIXEDSTRING NOT NULL,
"NAME" VARCHAR(30) CS_STRING NOT NULL,
"LATITUDE" DECIMAL(18, 10) CS_FIXED NOT NULL,
"LONGITUDE" DECIMAL(18, 10) CS_FIXED NOT NULL,
"REGION" VARCHAR(30) CS_STRING,
PRIMARY KEY (
"CODE"
)
);
Error: com.sap.hana.di.table: Syntax error: "incorrect syntax near" [8250009]
at "src/Tables/COUNTRIES.hdbtable" (2:17)
The editor does not recognize any CS types as keywords.
Is it missing a dependency or module that needs to be installed manually?
CS data types are not supported in HANA Cloud
The solution for this is to remove all CS-type definitions.
Thanks
Ayala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
10 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.