@denysobukhov  If this issue hasn't been resolved I am suspecting the HS2 idle Timeout and Thread pool size. Can you please do the below and share the out come. 1. Address Server-Side Resource or Timeout Issues Increase HiveServer2 Idle Timeout By default, HiveServer2 may close idle connections after a certain period. Increase this timeout: Update the HiveServer2 config: hive.server2.idle.session.timeout (default: 600000 ms / 10 minutes). Set it to a larger value, e.g., 3600000 (1 hour). hive.server2.idle.operation.timeout (default: 5 minutes for operations). Increase to match your app's use case. SET hive.server2.idle.session.timeout=3600000; SET hive.server2.idle.operation.timeout=3600000; Adjust Thread Pool Size If HiveServer2 runs out of threads to handle requests, it can drop connections: Increase hive.server2.threads to a higher value in HiveServer2 configurations. Restart HiveServer2 after changes. First check the default hive.server2.thrift.max.worker.threads  jstack -l <HiveServere2_ProccessId> | grep ".Thread.Stat" | wc -l Happy hadooping                                 ... View more

Any there from cloudera to help me on this issue..... ... View more

Yes, using HDFS to store, is there any limitation? ... View more

@Maicat You can not typecast array to the string. There are 2 ways you can use  1. Select the nth object of the array.     SELECT level5[0] AS first_genre FROM my_table;     WHere 0 is the first object 2. You can flatten it SELECT column1 FROM my_table LATERAL VIEW explode(level5) genre_table AS level5;          ... View more

f you deacivate and reactivate with "Public Locadbalancer" and "Public Executor", this should work ... View more

Got to know from the dev team that they have modified the column definition. We ran the MSCK repair table and we are able to run the select distinct query.  Vertex errors may not relate to memory issues. Hope this helps the community.  ... View more

very detailed and useful article. Thank you @asish!  ... View more

@yucai 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.  Thanks.@ ... View more

Thx for your answer, but I have problem that i don't know what fields can be null( my query will have a different columns in WHERE statment   ... View more