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.
The can error could mean special characters or a malformed SQL. Please post the SQL and sample data for debugging.
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.
ohhh..interesting! Thanks. will try and fix.
Best way to overcome HIVE_PARTITION_SCHEMA_MISMATCH error in Athena while preserving structure of structs?asked a month ago
Athena permission error running a queryasked 3 months ago
Athena -- Query exhausted resources at this scale factorasked 3 years ago
How to query .json.gz files from Amazon Athena?Accepted Answerasked 3 years ago
Encountering an issue with AWS Athena - HIVE_METASTORE_ERROR: Error: : expected at the position 63 ofasked 5 months ago
Row is not a valid JSON Object - JSONException: Expected a ',' or '}'asked a month ago
crawled data can not be queried in athenaAccepted Answerasked 5 years ago
Avoid metadata from Athena with Boto 3asked 2 months ago
Athena HIVE_METASTORE_ERROR when working with map<string, string> columns in parquet fileasked 3 months ago
Athena QuickSight query timesoutasked 4 months ago