Hi @LDAP , since you mentioned that the same query is working fine on Hue, could you try to set UseNativeQuery=1 on your driver configuration and retry the query. Reference: https://docs.cloudera.com/documentation/other/connectors/hive-jdbc/2-6-26/Cloudera-JDBC-Connector-for-Apache-Hive-Install-Guide.pdf (page 109) ... View more

Hi  Kalpit It seems you are using a custom installation of Hadoop and Hive and using MapReduce as an execution engine for Hive, which is deprecated.  Please refer to this article and see if it helps: https://community.cloudera.com/t5/Support-Questions/Getting-exception-while-inserting-the-file-having-multi/m-p/202630#M164636 if not please provide table DDL and insert command in use. Rgds   ... View more

Hi @allen_chu , Let me know if my understanding is correct  You are trying to insert data on Hive using spark thrift server and it is getting stuck. However, when you insert the data using beeline you managed to insert the data. Which CDP version you are using ?  Do you see any Yarn application getting created ? ... View more

hi @NagendraKumar , You can use puthiveql as described in this article https://community.cloudera.com/t5/Support-Questions/how-to-use-puthiveql-in-NIFI/td-p/204542 ... View more

@NagendraKumar  were you able to truncate the data with the processor that my colleague Smruti mentioned? ... View more

@NagendraKumar  were you able to truncate the data with the processor that my colleague Smruti mentioned? ... View more