Path is not absolute: s3://dataeng-on-yt-cleansed-us-east1-dev-1 This query ran against the "db_youtube_cleansed" database, unless qualified by the query.

Question

I successfully executed the Python query to convert the JSON format to Parquet format. The conversion was completed without any issues, and I can confirm the presence of the Parquet file and its columns. However, when attempting to execute the query using Athena, I encountered the following problem:

HIVE_UNKNOWN_ERROR: The path is not absolute: s3://dataeng-on-yt-cleansed-us-east1-dev-1. This query was executed against the "db_youtube_cleaned" database unless explicitly specified in the query.

Although the location and the Parquet file appear to be correct, the reason behind the issue is currently unknown.

Answer

https://repost.aws/questions/QUGDeWbV_TTnSyQBemuoInTA/hive-unknown-error-path-is-not-absolute-s3-deproject-on-youtube-athena-job-output-this-query-ran-against-the-db-youtube-cleaned-database-unless-qualified-by-the-query-please-post-the-error-mes

It appears that the same situation as the problem here is occurring.
May I ask you to check the contents of this page once?

It appears that the same situation as the problem here is occurring.  
May I ask you to check the contents of this page once?

Path is not absolute: s3://dataeng-on-yt-cleansed-us-east1-dev-1 This query ran against the "db_youtube_cleansed" database, unless qualified by the query.

Relevant content