Member since
11-11-2019
622
Posts
33
Kudos Received
25
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1634 | 02-28-2023 09:32 PM | |
2788 | 02-27-2023 03:33 AM | |
25284 | 12-24-2022 05:56 AM | |
2214 | 12-05-2022 06:17 AM | |
5703 | 11-25-2022 07:37 AM |
05-19-2023
12:16 AM
@Josh2023 could you please accept as solution,if this has fixed your issue?
... View more
05-18-2023
11:14 PM
1 Kudo
@Josh2023 can you try below: SET hive.exec.compress.output=false; SET hive.exec.dynamic.partition.mode=nonstrict; -- Create a temporary table or select data from existing tables INSERT OVERWRITE DIRECTORY '/path/to/output_directory/filename_' || from_unixtime(unix_timestamp(), 'yyyyMMdd') || '.csv' SELECT * FROM your_table;
... View more
03-20-2023
02:15 AM
@hive1 You need to follow https://docs.cloudera.com/runtime/7.2.10/using-hiveql/topics/hive-msck-repair.html
... View more
03-20-2023
01:42 AM
hi @hive1 WHat is the error you recieved? Can you also try with set hive.msck.path.validation=ignore
... View more
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