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

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?

주제

분석 서버리스 컴퓨팅 데이터베이스

태그

아마존 Athena AWS Lambda AWS Glue 데이터 추출, 변환 및 로드 아마존 Redshift

언어

English

Divyanshu

질문됨 7달 전275회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

수락된 답변

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.

전문가

Gonzalo Herreros

답변함 7달 전

Divyanshu
7달 전
Hi thanks, it worked, I just created a folder under that bucket and loaded my parquet there.

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

관련 콘텐츠