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

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ