topic Re: HANA Geospatial data types in Application Development and Automation Discussions

HANA Geospatial data types

Former Member — Thu, 27 Feb 2014 10:37:28 GMT

Hi pundits,

I am working on case where I need to show an example to store information in HANA Geospatial data types, can fetch it and put it into an local file. I awas going through the internet though I've got some information but not which can help me out.

Vaibhav

Re: HANA Geospatial data types

former_member184871 — Thu, 27 Feb 2014 10:54:44 GMT

Hi Vaibhav ,

Please refer :

http://scn.sap.com/thread/2100333

http://www.saphana.com/community/blogs/blog/2013/09/19/spatial-processing-with-sap-hana

And the reference guide:

http://help.sap.com/hana/SAP_HANA_Spatial_Reference_en.pdf]

Regards

Kumar

Re: HANA Geospatial data types

Former Member — Thu, 13 Mar 2014 11:23:16 GMT

Hi Kumar.

Thanks for the sharing the links. Now I have more knowledge of Geospatial data types. Now when I went ahead created the table with field having thesed spatial data type it is giving me error. Not so sure if I am doign anything wrong. Below the two sql queries.

1> create column table "IBMUSER"."LOCATION1"( "SNO" INTEGER null, "DESCRIPTION1" CHAR(100),

"LOCATION" ST_POINT)

Error:

"LOCATION" ...' in 290 ms 200 µs .

SAP DBTech JDBC: [257] (at 102): sql syntax error: incorrect syntax near "ST_POINT": line 2 col 12 (at pos 102)”

2> create column table "IBMUSER"."V_GEOSPATIAL" ("F_GEOMETRY" ST_GEOMETRY)

Error:

“SAP DBTech JDBC: [257] (at 60): sql syntax error: incorrect syntax near "ST_GEOMETRY": line 1 col 60 (at pos 60)”

Regards

Vaibhav