Skip to Content
0

Error while executing ST_COVERS in sql Hana SPS02

May 07 at 10:59 AM

16

avatar image
Former Member

HI

The below query fails in with error

Could not execute 'select * from "sap.ain.metaData::InstallationLocation.Address" where NEW ST_Polygon('POLYGON ...' in 296 ms 842 µs . SAP DBTech JDBC: [2048]: column store error: search table error: [6879] A spatial error occurred in the evaluator;object=NEO_AINCOMMITSTAGE::AIN_DEV:sap.ain.metaData::InstallationLocation.Addressen

Query

select * from "sap.ain.metaData::InstallationLocation.Address" where NEW ST_Polygon('POLYGON ((75.7232666015625 13.221229745578954, 75.27008056640625 12.71536762877211, 76.1846923828125 12.093038580274138, 76.61865234374999 13.007233869059881, 75.7232666015625 13.221229745578954))').ST_COVERS("Geometry") = 1;

The field Geometry is of type ST_GEOMETRY.

The version of hana is 2.00.023.00.1513691289 (fa/hana2sp02).

Could you please help.

Thank you

Regards

Vidhya

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member
May 07 at 12:04 PM
0

The query was wrong. Corrected query

select * from "sap.ain.metaData::InstallationLocation.Address" where NEW ST_Polygon('POLYGON ((75.7232666015625 13.221229745578954, 75.27008056640625 12.71536762877211, 76.1846923828125 12.093038580274138, 76.61865234374999 13.007233869059881, 75.7232666015625 13.221229745578954))').ST_COVERS(NEW ST_GEOMETRY("Geometry".ST_AsWKT())) = 1;

Share
10 |10000 characters needed characters left characters exceeded