Athena Troubleshooting

 

Error	Resolution
cannot recognize input near 'end' 'string'	end is the reserved keyword use backtick with the end e.g. `end` space is also a reserved keyword
CREATE EXTERNAL TABLE mismatched input 'external' invalidrequestexception	put PARTITIONED BY before ROW FORMAT
External keyword required for table type HIVE	Add "EXTERNAL" keyword in the create query
HIVE_BAD_DATA: Error parsing field value '1669254989383' for field 2: For input string: "1669254989383"	Change the field to BigInt datatype
HIVE_BAD_DATA: Error parsing field value for field 5: For input string: "1669280826369"	Change the field to timestamp datatype
INVALID_TABLE_PROPERTY: For input string: "1-12" (property: projection.month.digits)	add a comma in range instead of hyphen e.g. 1,12