Syntax error Use of SPATIAL function in SAP HANA

Use of SPATIAL function in SAP HANA



In SAP HANA, geospatial data types are not defined as such and you need to use scalar values like a.ST_X().

You can create a table like this −

CREATE COLUMN TABLE MYSCHEMA.SpatialShapes_GEOMETRIES (
   ShapeID integer,
   SHAPE1 ST_Point,
   SHAPE2 ST_GEOMETRY
);

SAP provides a complete guide to handle Geospatial data in applications. You can refer this link for more details:

https://help.sap.com/doc/PRODUCTION/9db42d044f8e415180d4a4475873b50a/2.0.00/en-US/SAP_HANA_Spatial_Reference_en.pdf


Updated on: 2020-02-17T08:11:42+05:30

272 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements