AWS Athena error

0

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

asked a year ago240 views
2 Answers
0

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.

profile pictureAWS
answered a year ago
0

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)
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content