Hi @Marks_08  In Hive is HBase dependency is enabled? If No, can you follow the below doc  https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/accessing-hbase/topics/hbase-configure-hive-hbase-pvc.html If yes, we require the complete HS2 logs as well as the Yarn application logs to troubleshoot further. Along with that share us the DDL for both Managed and external tables DESCRIBE FORMATTED <TABLE_NAME>; SHOW CREATE  TABLE <TABLE_NAME>; Replace TABLE_NAME with the managed and external tables. Thank You. ... View more

@denysobukhov  Based on error stack trace which you have shared looks like the connection is getting closed before fetching the results for the query. Is there a delay between submitting the query and then receiving the error? If yes, what is the delay exactly. During the time of error appears,have you observe any alerts from HS2 ? Are you able to  connect to HS2 from beeline without any issue during the time of  failure? Is hive2host.loc is the loadbalancer URL? We might require the JDBC TRACE LOGS and HS2 logs to determine the cause  of failure. Thank You. ... View more

@uinn Help us in letting know the heap size set for both Hive and Hive Metastore services. Is the issue happens while executing few specific queries or continuously the pause (JVM pause) is happening? Is it appears at HiveMetastore or at Hiveserver2 level? ... View more

Hi @EFasdfSDfaSDFG  From Hive the  following formats supported  : Parquet (default), Avro, ORC Create table examples: CREATE EXTERNAL TABLE test_ice_1 ( i INT, t TIMESTAMP, j BIGINT) STORED BY ICEBERG; CREATE EXTERNAL TABLE test_ice_2 (i INT, t TIMESTAMP) PARTITIONED BY (j BIGINT) STORED BY ICEBERG; CREATE EXTERNAL TABLE test_ice_3 (i int) STORED AS ORC STORED BY ICEBERG LOCATION ''; CREATE EXTERNAL TABLE test_ice_4 (i int) STORED BY ICEBERG TBLPROPERTIES ('key'='value', 'key'='value') CREATE EXTERNAL TABLE test_ice_1 (i int) STORED AS ORC STORED BY ICEBERG TBLPROPERTIES ('format-version' = '2'); ... View more