@octor You can tewk the split sizes if you are using Tez.   set tez.grouping.min-size=16777216;--16 MB min split set tez.grouping.max-size=64000000;--64 GB max split ... View more

This seems to be more of Spark. But I see below error:  java.io.FileNotFoundException: File does not exist: /warehouse/tablespace/external/hive/dim_cd_db.db/dim_subs_language_ivr/circle_id=14/part-00000-f53b4b78-8256-4040-9195-7af54c3365c8.c000.snappy.orc    Can you please check,if the file is present: hdfs dfs -ls/warehouse/tablespace/external/hive/dim_cd_db.db/dim_subs_language_ivr/circle_id=14/part-00000-f53b4b78-8256-4040-9195-7af54c3365c8.c000.snappy.orc Please also perfrom and let us know msck repair table dim_subs_language_ivr Try to run the same in hive beeline and check if the issue persists.   ... View more

@octor I see you have already raised https://issues.apache.org/jira/browse/HIVE-26720   May I know why do you want to change stripe size? ... View more

@pankshiv1809  I see you are getting Spark related error . Are you using Spark or Hive query ? ... View more

@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