Do Virtual Tables support ST_POINT or ST_GEOMETRY

[ozmike]

Hi 

I have a Virtual Tables connection from one hana data base to another. I am getting the error ST_POINT or ST_GEOMETRY is not supported when I use the the create virtual table statement. Are these types supported in Virtual Tables ? If not what is the work around . I am trying to migrate some data form one hana database to another using virtual tables. 

Thanks

[ozmike · Accepted solution]

ok create a view in source system to convert the GEO to text.

create or replace view MYSCHEMA.MYVIEW as ( select
GEOFIELD.ST_AsText() as GEOFIELDTEXT
from "MYSCHEMA.TABLE_WITH_GEO" ) ;

in target system create VT to connect to view

Once the VT is created

Then select GEOFIELDTEXT.ST_GeomFromText() as GEOFIELD  from VT 

The Geo types have been converted back.