10-09-2020 12:08 PM
I am getting the below error for incorrect syntax for ST_POLYGON have also notice in the create statement ST_POLYGON data is not getting bold in case if INT VARCHAR please can you support to identify the issue.
Thanks
10-09-2020 12:34 PM
Hi,
There are only two types of Spatial columns in HANA, ST_POINT, and ST_GEOMETRY.
Here ST_GEOMETRY is the supertype of all the other geometry types. That means all the other types would be under ST_GEOMETRY.
So to declare a Polygon using ST_POLYGON, declare the column type as ST_GEOMETRY and insert a sample polygon value as NEW ST_Polygon('Polygon((0 0, 0 1, 1 1, 1 0, 0 0 ))')
I highly recommend you to go through this Spatial Developer Guide.
Thanks
10-09-2020 7:13 PM
bande_ramesh91, you can have a look as well at the tutorials for SAP HANA Spatial: https://developers.sap.com/group.hana-aa-spatial-get-started.html and https://developers.sap.com/group.hana-aa-spatial-methods.html for the introduction before digging into the details of the Spatial Developer Guide.