Member since
11-11-2019
610
Posts
33
Kudos Received
25
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1498 | 02-28-2023 09:32 PM | |
2429 | 02-27-2023 03:33 AM | |
25058 | 12-24-2022 05:56 AM | |
2011 | 12-05-2022 06:17 AM | |
5223 | 11-25-2022 07:37 AM |
03-20-2023
01:11 AM
@hive1 Can you set below param: set hive.msck.path.validation=skip; Then use MSCK REPAIR TABLE tablename DROP PARTITIONS;
... View more
02-28-2023
09:32 PM
@APG_JWinthaegen I see you are getting OOM :java.lang.OutOfMemoryError: Java heap space Please try increasing container size and check set hive.tez.container.size=10240; set tez.runtime.io.sort.mb=4096; (40% of hive.tez.container.size) Please keep on increasing ,if it still fails. You can tweak the parameters in session level itself.
... View more
02-27-2023
03:33 AM
I see that you are using CDP 7.1.7. Follow below steps if youare using autoTLS 1. Check TrustStore Password: ====== # cat /etc/hive/conf/ssl-client.xml | grep -i -A1 "ssl.client.truststore.password" <name>ssl.client.truststore.password</name> <value>truststore_password</value> ====== 2. Below should be used for Kerberos + SSL beeline -u "jdbc:hive2://xxxxxx10000/default;principal=hive/xxxxx@CREAL;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks;trustStorePassword=trsutpwd"
... View more
02-27-2023
01:15 AM
@Nur 1. are you using SSL ? 2. Provide beeline -u "jdbc:hive2://Example.com:10000/default;principal=hive/Example.com@EXAMPLE.COM" --berbose=true 3. Hiveserver2 logs
... View more
02-06-2023
01:02 AM
@vi1 1. Navigate to CM ==> Hive on Tez ==> Configs ==> Configuration Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml 2. Set hive.server2.tez.initialize.default.sessions to false 3. Save and deploy change and start
... View more
01-18-2023
01:00 AM
If you want to delete all the tables in a database in one go DROP DATABASE database_name CASCADE;
... View more
01-18-2023
12:52 AM
hi @prakodi You can use below string 5000 times beeline -u "jdbc:hive2://server1.com:10000/default;principal=hive/server1.com@.com;" -e "drop table schemaDB.$tableName1" -e "drop table schemaDB.$tableName2" -e " "drop table schemaDB.$tableName3" ................ >> $drop.log Please mark this as RESOLVED,if your queries are answered.
... View more
12-24-2022
05:56 AM
2 Kudos
@wert_1311 In CDP hive.server2.tez.initialize.default.sessions is set to true by default, that means when Hiveserver2 starts then applucation master also starts. By defalt the number of AM is 1, so the parallelism does not exists,one Tez job has to wait until other is finished. Navigate to CM ==> Hive on Tez ==> COnfigs ==> Safety valve for Hiveserver2 hive-site.xml Add hive.server2.tez.initialize.default.sessions= false Restart and check Please accept as SOlution, if the action plan has worked.
... View more
12-23-2022
07:04 AM
@reca Do you have Ranger enabled? You can check in Ranger audits.
... View more
12-20-2022
07:12 AM
@kvbigdata The canary test fails when HMS is busy ? Is it intermittent and does it fix by its own ?
... View more