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

已提问 1 年前243 查看次数
2 回答
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
已回答 1 年前
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)
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则