By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

0

Trying to query a json file but getting an error

HIVE_METASTORE_ERROR: Error: : expected at the position 63 of 'array<struct<picture_link_text:string,title_text:string,Created Date:string,Created By:string,Modified Date:string,_id:string>>' 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.

  • Kunal_G
    2 years ago

    The can error could mean special characters or a malformed SQL. Please post the SQL and sample data for debugging.

Topics
Analytics
Tags
Amazon AthenaAWS Glue
Language
English
TheAbyssKeepsStaringAtMe
asked 2 years ago2161 views
2 Answers
0

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.

javier
answered 2 years ago
0

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

TheAbyssKeepsStaringAtMe
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content