INCORRECT SYNTAX ERROR NEAR ST_POLYGON

[former_member698032]

st-polygon-error.jpgHi

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

[Former Member]

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

[Vitaliy-R]

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.