HIVE_BAD_DATA: Not valid Parquet file:
Hi Team, Me trying to build Cost and usage analysis using Glue & Athena. Referring https://wellarchitectedlabs.com/cost/200_labs/200_4_cost_and_usage_analysis/2_setup_athena/. While previewing the table facing following error:
HIVE_BAD_DATA: Not valid Parquet file: s3://aws-s3-access-inventory/NS/NS-AWS-CUR/20220201-20220301/20220221T114629Z/NS-AWS-CUR-Manifest.json expected magic number: PAR1 got: This query ran against the "cost" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 28d914a4-7640-4641-9c72-627d48cb02f0
The json file does exists in stated folder under bucket.
Please assist.
Regards, Nikhil Shah
I think those labs might be out of date. This one I know works: https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/
Relevant questions
Glue job s3 file not found exception
asked 5 years agoAthena HIVE_METASTORE_ERROR when working with map<string, string> columns in parquet file
asked 5 months agoOpen a parquet file locally
Accepted Answerasked a month agoHIVE_BAD_DATA: Not valid Parquet file:
asked a month agoCost of Athena and glue
asked 7 months agoQuicksight Athena - analysis error: "HIVE_UNSUPPORTED_FORMAT: Unable to create input format"
asked a month agoCost explorer boto3 cost and usage without specific tag
asked 6 months agoNot able to read S3 Parquet file
asked 3 months agoHow fast can glue ETL convert data to parquet?
Accepted AnswerHIVE_PARTITION_SCHEMA_MISMATCH - Athena error on S3 Parquet file
asked 2 months ago
Hi Aaron, Thank you, will review the lab and confirm.
Regards, Nikhil Shah