- 최신
- 최다 투표
- 가장 많은 댓글
Based on the error , it looks like the table is pointing to a location which has a json file
s3://deng-utube-raw-us-east-1-dev/youtube/raw_stats_reference_data/FR_category_id.json
Can you verify the following ?
1- What is the Athena Table DDL showing up as LOCATION ?
2- If the location is pointing to raw bucket , then it's a valid error .
3- Verify the LOCATION of your table and point it to destination bucket /location which has only parquet file.
I guess the S3 prefix you've told Athena to use contains json files somewhere? It would be best to have separate prefixes for your json and parquet files, and configure Athena to just use the parquet files' prefix.
I have figured it out...the problem lied in the location of destination bucket. Thankyou for the response.
관련 콘텐츠
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 일 년 전
I have figured it out...the problem lied in the location of destination bucket. Thankyou for the response.