I am currently working on creating custom hierarchy to drill down from Country -> City on SAC geo map using HANA live. I am referring following blogs to create custom hierarchy:
While executing the procedure, I am facing below error :
exception 1600600: Function ST_Centroid() does not support geometries of type ST_Point at "st_centroid" function
Kindly provide your valuable inputs on how this error can be fixed.
Please note that I am populating data to "Shape" field using function "ST_GeomFromText('POINT(' || "LONG" || ' ' || "LAT" ||')', 4326).ST_Transform(3857)" not through ESRI shape files.