Skip to main content

Posts

Featured

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

Latest posts

AWS Athena Glue troubleshooting

How to get epoch time in millis in Java?

Add OR and AND condition in json path query

JsonPath query for nested json in an array

AWS lambda internal server error 502

java.lang.NoClassDefFoundError $$inlined$forEach$lambda$1 in Kotlin

Plugin [id: 'org.jetbrains.kotlin.jvm', version: 'X.X.X'] was not found in any of the following sources

Important scp commands

Spark runs on Yarn cluster exitCode=13