Could help to explain what's the meaning of first 2 sentence?  Set Hive.....   What would happen if we don't have 2 sentences? How would that impact our query?   Thanks.         ... View more

@Orcs    Hive aux JARs path In CDP Private Cloud Base, click Cloudera Manager > Clusters and select the HIVE. Click Configuration and search for Hive Auxiliary JARs Directory. Specify a directory value for the Hive Aux JARs property if necessary, or make a note of the path. Upload the JAR to the specified directory on all Hive metastore instances. Click Cloudera Manager > Clusters and select the HIVE-ON-TEZ. Click Configuration and search for Hive Auxiliary JARs Directory. Upload the JAR to the specified directory on all HiveServer instances.   ... View more

check TBLPROPERTIES if transctional=ttrue, if yes, insert overwrite would work ... View more

@sandipkumar, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  ... View more

Hi,      sorry for the late reply   nope, I still get this error   Error: Error while compiling statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1647249588842_0007_1_00, diagnostics=[Vertex vertex_1647249588842_0007_1_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: coach_nouveau_rapport_qi_filtered initializer failed, vertex=vertex_1647249588842_0007_1_00 [Map 1], java.io.FileNotFoundException: No such file or directory: ...     indeed, it cannot find the table, because it  does not exist on AWS S3     ... View more

yes, It exists in the hive CDH source. org.apache.hadoop.hive.ql.udf package is part of hive-exec.jar. PFB [hive@node3 lib]$ /usr/jdk64/jdk1.8.0_112/bin/jar -tvf hive-exec.jar | grep "org.apache.hadoop.hive.ql.udf" | wc -l 660 ... View more

@asish  - 220 GB - 36 executors per daemon. - in a daemon : 144 GB for the heap, 60 GB for the cache, 16 GB for the headroom. ... View more

Did u see these alerts once you enabled SSL in the cluster? ... View more