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

demandé il y a un an243 vues
2 réponses
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
répondu il y a un an
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)
répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions