- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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.
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
I have figured it out...the problem lied in the location of destination bucket. Thankyou for the response.