I have a table with a geometry column and if I query it using PostGIS, it shows the records right:
PostGIS query image
The problem is when I execute the query using Apache Drill, because it shows all the records fine except the geometry one, it shows as null.
Drill query image
If I use:
cast(geom_multipolygon as varchar(255))
it shows the varchar representation of the geometry, another option is getting the MULTIPOLYGON text and transform to Drill binary using ST_GeomFromText(geom)
, but we need the binary format directly from PostGIS, so those approaches can’t be done.
We have seen this page: https://github.com/k255/drill-gis/issues/1 but the proposed solution doesn’t work for us, so I think there is a way to achieve this.