I want to create a join a table that I will call
objects and a table that I call
objects table has a geometry ID that is also present in the
geometries table. Other than the geometry ID, the
geometries table has three additional columns with point, polygon and multipolygon information.
However when I run the following SQL query:
SELECT * FROM objects INNER JOIN geometries ON geometries.geometry_id= objects.geometry_id LIMIT 100
I get the following exception:
Exception: Columnar conversion not supported for variable length types
I tried changing what I am joining on what or directly writing this to a new table. However, all of these queries had the same issues in the end.
I am aware that this touches on the know issues but I was wondering whether this is absolutely impossible or whether you have any idea on how to bring together information of the
geospatial with the
Thanks so much in advance
Please sign in to leave a comment.