I found other simple solution for this issue, Simply find faulty partition from partition list by using command. show partitions table table_name;   then rename the faulty partition to some other name in correct format of your partition. In my case, I used ALTER table table_name partition (date_flag='2021-11-25_bak') rename to partition (date_flag='2021-01-01'); ... View more

Here's why: https://issues.apache.org/jira/browse/KAFKA-5089 Workaround/Hack: Force Kafka COnnect libs like javax.ws.rs-api-2.0.1.jar to appear on the classpath first by exporting your CLASSPATH variable before running connect-standalone.sh export CLASSPATH=/usr/hdp/2.6.4.0-91/kafka/libs/* ... View more

Hi @Gnanasekaran G, is there an OVERRIDE command in your statement? You may be running into this issue - https://issues.apache.org/jira/browse/HIVE-4605 ... View more

thank you @Frank Welsch. I'll check ... View more

Thanks @Gnanasekaran G please accept best answer. we can close the thread ... View more

@Gnanasekaran G if this helped, please vote/accept best answer. we can close the thread ... View more

If you're looking for a standalone tool to convert CSV to ORC have a look at https://github.com/cartershanklin/csv-to-orc It's a standalone Java tool that can run anywhere, including off of your Hadoop cluster. It supports custom null strings, row skipping and basic Hive types (no complex types currently) ... View more