@chengxi  Are you using CDP ?   replicate the issue and provide    /var/log/hive/ /var/run/cloudera-scm-agent/process/<hive that crashed>/logs ... View more

@gambarno COuld you please point the document stating 'OVERWRITE keyword is mandatory" ... View more

@mareb  Can you please attach application logs for application_1657267798389_0085 ... 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 its mentioned /tmp/hs_err_pid1.log ... View more

@grlzz apologies for the late response.   I am assumimg Tez job fails. Can you use     select distinct column from tablename to check if this works. ... View more

@sandipkumar we can get to know from hs_err_pid1.log ... View more

hi @grlzz    I dont quite understand what do you mean by table is missing ?   Please concentrate on table1. Does the table1 yield correct results after collecting STATISTICS? ... View more

@grlzz Can you please colect STATS and run again?   https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.5/bk_cloud-data-access/content/hive-analyzing-tables.html ... View more