topic INCORRECT SYNTAX ERROR NEAR ST_POLYGON in Application Development and Automation Discussions

INCORRECT SYNTAX ERROR NEAR ST_POLYGON

former_member698032 — Fri, 09 Oct 2020 11:08:07 GMT

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

Re: INCORRECT SYNTAX ERROR NEAR ST_POLYGON

Former Member — Fri, 09 Oct 2020 11:34:39 GMT

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

Re: INCORRECT SYNTAX ERROR NEAR ST_POLYGON

Vitaliy-R — Fri, 09 Oct 2020 18:13:54 GMT

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.