Athena Geospatial Queries limitations

user_13465436 0
Viewed 52

I came across AWS documentation on Geospatial queries and they mentioned it supports only in two formats WKT (Well-known Text) and JSON-encoded geospatial data

My aim is to run geospatial queries in parquet format, Is this possible to do so? or do it need to use only one of the two data formats?

enter image description here

parquet amazon-athena aws-glue sql json
1 Answers

It's real, athena lacks good features present in other engines. But fortunately you can save your data as text / wkt inside a parquet.

Athena allows you to create tables through cte where you can specify the file type as csv , parquet gzip text

user_44509510
Related