Athena Error- HIVE_BAD_DATA: Not valid Parquet file: s3://deng-utube-raw-us-east-1-dev/youtube/raw_stats_reference_data/FR_category_id.json expected magic number: PAR1 got: ] }

0

Not able to display paruqet file in athena , which json is converted into parquet using lambda function

1 Answer
0

You are trying to read json files in a table defined as parquet format.
If that json file is there by mistake then delete any json files, otherwise recreate the table to be a json one.

profile pictureAWS
EXPERT
answered a year ago
  • I have figured it out...the problem lied in the location of destination bucket. Thankyou for the response.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions