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.