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.
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.
Relevant questions
Best way to overcome HIVE_PARTITION_SCHEMA_MISMATCH error in Athena while preserving structure of structs?
asked a month agoAthena permission error running a query
asked 3 months agoAthena -- Query exhausted resources at this scale factor
asked 3 years agoHow to query .json.gz files from Amazon Athena?
Accepted Answerasked 3 years agoEncountering an issue with AWS Athena - HIVE_METASTORE_ERROR: Error: : expected at the position 63 of
asked 5 months agoRow is not a valid JSON Object - JSONException: Expected a ',' or '}'
asked a month agocrawled data can not be queried in athena
Accepted Answerasked 5 years agoAvoid metadata from Athena with Boto 3
asked 2 months agoAthena HIVE_METASTORE_ERROR when working with map<string, string> columns in parquet file
asked 3 months agoAthena QuickSight query timesout
asked 4 months ago
The can error could mean special characters or a malformed SQL. Please post the SQL and sample data for debugging.