HIVE_UNKNOWN_ERROR: Path is not absolute: s3://u2b-cleansed-data

Question

I have converted a json format file in parquet, I can see the parquet file and the columns, but while querying with Athena getting error.
HIVE_UNKNOWN_ERROR: Path is not absolute: s3://u2b-cleansed-data
This query ran against the "u2b_cleansed_data" database, unless qualified by the query. 
While doing "show create table", I am able to see location is   's3://u2b-cleansed-data'
what can be the issue here?

Accepted Answer

You should not put the table files directly under the bucket, all these systems assume there is a DataWarehouse path under which there is a folder for each table (even if you have one).  
In your case the table path is null and that is problematic for many tools, that's why I think it means that "not absolute error" in this tool, on others you can just get a null path error.

HIVE_UNKNOWN_ERROR: Path is not absolute: s3://u2b-cleansed-data

Relevanter Inhalt