Use of SPATIAL function in SAP HANA

SAPSAP 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


raja
Published on 21-Dec-2017 12:23:15
Advertisements