Cloudera Community
asish
user rank
user rank
Guru

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

by Community Manager Community Manager in Support Questions
‎11-20-2022 08:49 PM
1 Kudo
‎11-20-2022 08:49 PM
1 Kudo
@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? ... View more

Re: How are you protecting Hive views

by Guru Guru in Support Questions
‎11-19-2022 12:15 AM
‎11-19-2022 12:15 AM
@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. ... View more

Re: Configure HA database for Hive Metastore

by Guru Guru in Support Questions
‎11-14-2022 03:44 AM
1 Kudo
‎11-14-2022 03:44 AM
1 Kudo
@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 ... View more

Re: hive pyspark integration

by Guru Guru in Support Questions
‎11-13-2022 06:52 PM
‎11-13-2022 06:52 PM
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 ... View more

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

by Guru Guru in Support Questions
‎11-11-2022 03:18 AM
‎11-11-2022 03:18 AM
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)     ... View more

Re: Query Hive Using Python Getting below error

by Guru Guru in Support Questions
‎11-11-2022 03:14 AM
‎11-11-2022 03:14 AM
thank you @pankshiv1809  ... View more

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

by New Contributor in Support Questions
‎09-08-2022 06:19 AM
‎09-08-2022 06:19 AM
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 ... View more

Re: Hive Multi Table insert extension questions

by Frequent Visitor in Support Questions
‎08-24-2022 01:32 AM
‎08-24-2022 01:32 AM
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         ... View more

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

by Explorer in Support Questions
‎08-15-2022 10:19 AM
‎08-15-2022 10:19 AM
Te problem improved upgrading the driver version. It still persists, but is rarer. ... View more

Re: HIVE MAJOR Compaction fails for one specific p...

by Community Manager Community Manager in Support Questions
‎08-12-2022 05:23 AM
‎08-12-2022 05:23 AM
@mareb you could use a code/text sharing service to store the code and share the link here ... View more
Contact Me
Online
Offline
Last Visited
‎10-29-2025 05:13 AM
Community Statistics
Member Since ‎11-11-2019 12:46 AM
Last Visited ‎10-29-2025 05:13 AM
Posts 634
Kudos received 26