Member since
06-11-2021
5
Posts
1
Kudos Received
0
Solutions
11-01-2021
10:58 PM
1. We need to know on which database Hive metastore is hosted like my SQL, Oracle?
2. What is the version of jdbc driver used for a database connection?
if Oracle then, we need to know which version it has by this command
unzip -p /usr/share/oracle-connector-java.jar | head > jar_version.txt
Right now we are using ojdbc8.jar.
Solution:
Using the following command, move the existing oracle-connector-java.jar from /usr/share/java/ to /tmp/ mv /usr/share/java/oracle-connector-java.jar /tmp/
Using the following command, copy the existing ojdbc8.jar as oracle-connector-java.jar cp /usr/share/java/ojdbc8.jar oracle-connector-java.jar
Using the following command, change the permissions to 775 chmod 775 oracle-connector-java.jar
Restart the Hive service
Disclaimer: This article is contributed by an external user. The steps may not be verified by Cloudera and may not be applicable for all use cases and may be very specific to a particular distribution. Please follow with caution and at your own risk. If needed, raise a support case to get the confirmation.
... View more
11-01-2021
10:52 PM
If any user/admins are not able to view the container logs. And the applications are running with Spark service. Looks like ACLs are not configured. Add this in your clusters:
Go to Cloudera Manager -> Spark -> Configuration -> Spark Client Advanced Configuration Snippet (Safety Valve) for spark-conf/spark-defaults.conf spark.acls.enable= true
spark.admin.acls=username1,username2
spark.admin.acls.groups=group1,group2
Set spark.ui.view.acls=username1,username2
spark.ui.view.acls.groups=group1,group2
Set spark.modify.acls=user1,user2
spark.modify.acls.groups=group1,group2
If you pass * as value it will give access to all the users. And both user[admin.acls] and groups[admin.acls.groups] accept both username and groups as comma-separated values.
Both user and group lists use a comma-separated list of entries. The wildcard character “*” allows access to anyone, and the single space “ “ allows access to no one.
Regards,
Naresh.B
Disclaimer: This article is contributed by an external user. The steps may not be verified by Cloudera and may not be applicable for all use cases and may be very specific to a particular distribution. Please follow with caution and at your own risk. If needed, raise a support case to get the confirmation.
... View more
Labels:
10-31-2021
02:40 PM
Hi , Could you please login to the CM host and check the logs. And check the server and agent logs., you will get/find the issue what it is? Other wise please share the logs. Regards, Naresh.B
... View more
09-21-2021
06:33 AM
Hi Team, How do we identify hive metastore performance and which tables/dbs causing more pressure on Hivemetastore and number of connections on HMS? Regards, naresh.B
... View more
Labels:
- Labels:
-
Apache Hive
08-04-2021
12:28 AM
Hi Nazar, 1) Please click on the Edit driver settings in the dbeaver, please fallow my below image and try. 2)And add the ImpalaJDBC drivers What ever I was masked there, you can use impalaVIP if you have otherwise please Impala Daemon Host. 3)In driver properties, please check this property and value AllowSelfSignedCerts=1 4) Later try with username and password. It will work. Regards, Naresh.B
... View more