AWS Athena error

Question

HIVE_UNKNOWN_ERROR: Path is not absolute: s3://datapipeline-youtube-json-cleaned-data-23
This query ran against the "" database, unless qualified by the query.

The data is present in the s3 path but it is not getting queried

Answer

Can you please check on these points ?

1. Did you run the Glue crawler for Athena to be aware of the table ? 
2. Do you see the database in Athena where the table is ?
3. Is your query prefixed with the database name ? ( not required always but good to have)

Answer

I'm not sure what is causing your specific error, but make sure you append a trailing / to the location. If you could your table definition and the query you are trying to execute, that would help further troubleshoot the error.

AWS Athena error

Contenido relevante