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.

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

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년 전
The can error could mean special characters or a malformed SQL. Please post the SQL and sample data for debugging.

주제

분석

태그

아마존 Athena AWS Glue

언어

English

TheAbyssKeepsStaringAtMe

질문됨 2년 전2170회 조회

2개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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

답변함 2년 전

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

TheAbyssKeepsStaringAtMe

답변함 2년 전

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

관련 콘텐츠