Encountering an issue with AWS Athena - HIVE_METASTORE_ERROR: Error: : expected at the position 63 of

Question

Trying to query a json file but getting an error

HIVE_METASTORE_ERROR: Error: : expected at the position 63 of 'array>' but ' ' is found.

Just getting started with Athena so have no idea what I am doing wrong.

Any ideas? This table was imported by Glue.

Answer

I can see some of your column names have spaces in their names, which are not supported by Athena. I've experienced a lot of this type of cryptic error messages when using a dash on my column names. The only special character allowed is the underscore, as seen at https://docs.aws.amazon.com/athena/latest/ug/tables-databases-columns-names.html

You would need to change the column names to use Athena on that dataset.

Answer

ohhh..interesting! Thanks. will try and fix.

Encountering an issue with AWS Athena - HIVE_METASTORE_ERROR: Error: : expected at the position 63 of

Contenido relevante