HIVE_BAD_DATA: Error reading field value: Cannot convert value dfeeb180681a61d609a of type String to a LONG value

The query is working on 1 table with a CSV source file. After adding 2 more columns to the same file it is giving me an error for the normal select query.

HIVE_BAD_DATA: Error reading field value: Cannot convert value dfeeb180681a61d609a of type String to a LONG value

Topics

Analytics Storage

Relevant content

Glue ETL converts NULL values of Snowflake columns to 0
Kyle Ahn
asked a year ago
Athena Table timestamp column with null values
alvinz
asked a year ago
Method for converting all values of a field to string when querying with Ion SerDe?
wfchang
asked 2 years ago
Error reading field value: Cannot convert value FAILE
Alexandre Diogo dos Santos
asked a year ago
How do I resolve the "CharacterStringTooLong (Value is too long) encountered with {Value}" error that I receive when creating a TXT record using DKIM syntax?
AWS OFFICIALUpdated a year ago
Why do EC2 instances of the same instance type show different CPU MHz values?
AWS OFFICIALUpdated 6 months ago
Why do I get the error "HIVE_BAD_DATA: Error parsing field value for field X for input string:" when I query JSON data in Amazon Athena?
AWS OFFICIALUpdated 3 months ago
Why does my Athena query fail with the error "HIVE_BAD_DATA: Error parsing field value for field X: For input string: "12312845691""?
AWS OFFICIALUpdated 2 months ago
Push down queries when using the Google BigQuery Connector for AWS Glue
EXPERT
Fabrizio@AWS
published 2 years ago
Creating a DynamoDB Table with CloudFormation and Adding Items at Creation Time
EXPERT
Leeroy Hannigan
published 10 months ago