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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南