Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
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
    vor 2 Jahren

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

Themen
Analysen
Tags
Amazon AthenaAWS Glue
Sprache
English
TheAbyssKeepsStaringAtMe
gefragt vor 2 Jahren2170 Aufrufe
2 Antworten
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
beantwortet vor 2 Jahren
0

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

TheAbyssKeepsStaringAtMe
beantwortet vor 2 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt