About Mounika_Reddy

Mounika_Reddy · ‎10-25-2024

Hi @Edu7478 Help us in sharing the below details Exact CDP and CM version . During the time of issue appears provide us the HS2 and HMS logs from all nodes Is table is partitioned table? Share us the DDL for the same DESCRIBE FORMATTED pro_con.dmcrp001_th_importe_consolidado_contrato; SHOW CREATE TABLE pro_con.dmcrp001_th_importe_consolidado_contrato; Try with following setting at session level set hive.stats.autogather=false; and rerun the query .If it fails let us know For more info refer the below KB article https://community.cloudera.com/t5/Customer/Alter-Table-Fails-With-quot-Unable-to-alter-table-Cannot/ta-p/380703 Thank You.

Mounika_Reddy · ‎09-11-2024

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.

Mounika_Reddy · ‎09-11-2024

@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.

Mounika_Reddy · ‎07-09-2024

@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?

Mounika_Reddy · ‎06-17-2024

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');

Mounika_Reddy · ‎06-04-2024

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.

Mounika_Reddy · ‎06-04-2024

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?

Online	Offline
Last Visited	‎11-20-2024 04:22 AM

Member Since	‎06-25-2020 03:22 AM
Last Visited	‎11-20-2024 04:22 AM
Posts	40
Kudos received	3

Cloudera Community

Re: Error when do an alter table change column on ...

Re: Error when do an alter table change column on ...

Re: Issue trying to insert into Managed Table from...

Re: [Cloudera][HiveJDBCDriver](500593) Communicati...

Re: HiveServer2 often has internal pauses

Re: Creating Iceberg table

Re: Creating Iceberg table

Re: Creating Iceberg table