About asish

VidyaSargur · ‎11-20-2022

@hanumanth, Have the replies helped resolve your issue? If so, can you please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future?

VidyaSargur · ‎11-20-2022

@chengxi, Have you resolved your issue? If you have, can you please provide the appropriate solution here, so that it can help other users in the future? If you are still experiencing the issue, can you provide the information our experts have requested?

asish · ‎11-19-2022

@NikoBelic Thanks for the update. The hive metadata indeed is stored on database. You need to take the dump to backup the metadata. Please let me know,if you have nay queries. Please "Accept as Solution" ,if your queries are answered.

asish · ‎11-14-2022

@KPG1 I can think of Oracle database ha a feature i.e Oracle RAC,where we give SCAN address as the jdbc string to metastore,so the scan ip wll take care of loadbalancing. You need to check with mysql vendor(Oracle),if they have similar thing as of Oracle database. You can have HMS HA but all the HMS instance point to same database, you can not have 2 HMS instance pointing to a different database. Please let me know,if you have any querties and please "Accept As Solution", if your queries are answered

asish · ‎11-13-2022

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

asish · ‎11-11-2022

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)

asish · ‎11-11-2022

thank you @pankshiv1809

cesar_rodriguez · ‎09-08-2022

This issue is still present in CDP 7.1.7 sp1. We had to edit the advanced snippet for hive-site.xml for the Metastore service and add: metastore.storage.schema.reader.impl org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader

gambarno · ‎08-24-2022

In the hue help Multiple insert clauses (also known as Multi Table Insert) can be specified in the same query. The output of each of the select statements is written to the chosen table (or partition). Currently the OVERWRITE keyword is mandatory and implies that the contents of the chosen table or partition are replaced with the output of corresponding select statement. Probably I'm misunderstanding something

PauloNeves · ‎08-15-2022

Te problem improved upgrading the driver version. It still persists, but is rarer.

Online	Offline
Last Visited	‎12-18-2025 02:43 AM

Member Since	‎11-11-2019 12:46 AM
Last Visited	‎12-18-2025 02:43 AM
Posts	635
Kudos received	27

Cloudera Community

Re: Impala's log "ORC read request to already read...

Re: DBeaver connection issue with CDP Hive.

Re: hive vertex error unknown cause.

Re: ERROR: Connecting to Kerberos Enabled Hive usi...

Re: Data not inserting in hive table (CDP)

Re: Hive external table MSCK and DROP not working....

Re: kerberos fails to be installed and hive cannot...

Re: How are you protecting Hive views

Re: Configure HA database for Hive Metastore

Re: hive pyspark integration

Re: How to set orc.stripe.size value in hive table...

Re: Query Hive Using Python Getting below error

Re: message:java.lang.UnsupportedOperationExceptio...

Re: Hive Multi Table insert extension questions

Re: Hive ODBC fails to list all tables and returns...