@mohammad_shamim For copying ACID tables from one cluster to another you can use import and export commands .Below are the steps in detail 1)On source cluster create new table using create-table-as-select on source acid table. create table src_table as select * from src_acid_table; 2)Then run export on src_table. export table src_table to '/data/src_table_export' 3)Copy the directory /data/src_table_export to destination cluster 4)Run import on destination cluster as below once data is copied. import table dst_table from '/data/src_table_export' 5)Create new acid table same as source and then insert the data as below: insert into table dst_acid_table select * from dst_table; Verify that data on both source and target table were consistent by taking count of rows.   ... View more

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

Hi , Below is the syntax for creating iceberg tables using impala 1)create table test(id int, name string) stored by iceberg; insert into test values(1,"M");  2)create table test_iceberg (id int, name string) stored by iceberg; LOAD DATA INPATH '<path_of_file>' INTO TABLE test_iceberg; 3)CREATE EXTERNAL TABLE test_iceberg_1 STORED AS ICEBERG LOCATION '/path/to/table' TBLPROPERTIES('iceberg.catalog'='hadoop.tables'); If the data exits in ozone make sure you have the enough privileges to access the same For more info ,we suggest you to refer the https://impala.apache.org/docs/build/html/topics/impala_iceberg.html Hope the info helps. ... View more

Hi , Can you confirm with the version details also let us know you are using Hue--Hive Editor or Hue--Impala editor to create the iceberg table? ... View more