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

Question

I have ran the python query to transform the json format to parquet format and it was completed successfully, I can see the parquet file and the columns, but when I try to run the query using Athena, im facing below issue

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.

I can see the location was correct and parquet file also present, but not sure why it is not working

Answer

Hello,

Thanks for response , I found out what was the issue, when I run crawler two tables are getting updated with same results, only one table is pointing to correct s3 ;location, after deleting duplicate table, now it is working fine.

Answer

Run: ```SHOW CREATE TABLE `your table name here`;``` and check the property  LOCATION, do you see any strange characters before s3://?  
Also, I wonder if it works when locating the table to the root of a bucket, without any folder, you are expected to have a folder per table.

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

Relevant content