HIVE_BAD_DATA: Error Parsing Field Value for Field ERROR in AWS Athena
HIVE_BAD_DATA is generally related to bad data in source file or data type mismatch. I have experienced this error while working with JSON data read in AWS Athena. For example, I have below sample JSON data that is stored in s3 bucket And here is external table DDL statement. Since socialdata field forming…