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: ] }

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.