Run the equivalent query in beeline and share the below if you encounter the error:    1. beeline trace => This should contain queryID and query   2. HS2 logs    3. application log   This will help us to analyse ... View more

Please set  hive.fetch.task.conversion=more, and try the query hive.fetch.task.conversion=none, and try the query ... View more

You can set  tez.grouping.max-size to 1gb.   Please increase below   set hive.tez.container.size=10240; set tez.runtime.io.sort.mb=4096; (40% of container size)     ... View more

thank you @pankshiv1809  ... View more

@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