Skip to Content
0
Former Member
Jan 12, 2016 at 04:34 PM

Spatial Columns in hdbtable definition

467 Views

Hi All,

I have created my tables using HANA developer perspective using *.hdbtable files

Now I want to add spatial fields to this table by editing this definition file

Any help is appreciated

Thanks

I want to add a field

CORD of type ST_POINT to this table

Current Definition :

table.schemaName = "LOC";

table.tableType = COLUMNSTORE;

table.columns = [

{name = "ZIPID"; sqlType = INTEGER; nullable = false;},

{name = "ZIPCODE"; sqlType = NVARCHAR; nullable = false; length = 5; },

{name = "ZIPCODETYPE"; sqlType = NVARCHAR; nullable = true; length = 10; },

{name = "CITY"; sqlType = NVARCHAR; nullable = true; length = 100; },

{name = "STATE"; sqlType = NVARCHAR; nullable = true; length = 2; },

{name = "LOCATIONTYPE"; sqlType = NVARCHAR; nullable = true; length = 20; },

{name = "LAT"; sqlType = DECIMAL; nullable = true; precision = 10; scale = 6;},

{name = "LONG"; sqlType = DECIMAL; nullable = true; precision = 10; scale = 6;},

{name = "XAXIS"; sqlType = DECIMAL; nullable = true; precision = 5; scale = 2;},

{name = "YAXIS"; sqlType = DECIMAL; nullable = true; precision = 5; scale = 2;},

{name = "ZAXIS"; sqlType = DECIMAL; nullable = true; precision = 5; scale = 2;},

{name = "REGION"; sqlType = NVARCHAR; nullable = true; length = 2; },

{name = "COUNTRY"; sqlType = NVARCHAR; nullable = true; length = 2; },

{name = "LOCATIONTEXT"; sqlType = NVARCHAR; nullable = true; length = 100; },

{name = "LOCATION"; sqlType = NVARCHAR; nullable = true; length = 100; },

{name = "DECOMMISIONEDFLAG"; sqlType = NVARCHAR; nullable = true; length = 5; }

];

table.primaryKey.pkcolumns = ["ZIPID"];