En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
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
    il y a 2 ans

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

Sujets
Analytique
Balises
Amazon AthenaAWS Glue
Langue
English
TheAbyssKeepsStaringAtMe
demandé il y a 2 ans2170 vues
2 réponses
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
répondu il y a 2 ans
0

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

TheAbyssKeepsStaringAtMe
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents