Skip to Content
avatar image
Former Member

Error while executing ST_COVERS in sql Hana SPS02

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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;

    Add comment
    10|10000 characters needed characters exceeded