Member since
10-28-2020
504
Posts
31
Kudos Received
36
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
84 | 05-05-2024 01:09 PM | |
153 | 03-28-2024 09:51 AM | |
245 | 03-20-2024 03:54 AM | |
448 | 03-14-2024 06:29 AM | |
668 | 03-12-2024 04:00 AM |
05-08-2024
06:03 AM
@shofialau great! Now we can download mysql jdbc connector and place in the HMS node under the location /usr/share/java Detailed information can be found here - https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade-hdp/topics/amb-install-mysql-jdbc.html#pnavId2
... View more
05-07-2024
03:03 AM
1 Kudo
Hello @smruti , Thanks for the help.
... View more
05-01-2024
05:57 AM
@MorganMcEvoy what is cluster-head.domain.com? Is this a load balancer or an individual HS2 node? Also, what's the client tool you are using? Is it possible that it is not honoring the sslTrustStore parameter? A workaround would be to import the root ca cert into the default java truststore in the client machine. ref: https://stackoverflow.com/questions/11700132/how-to-import-a-jks-certificate-in-java-trust-store
... View more
04-11-2024
05:48 AM
JDBC/ODBC Drivers for Hive can be downloaded from Cloudera website. The first thing we need to collect is the Hive Endpoint from Cloudera Management console. This can be found at the bottom of in the specific DataHub window. It will be in the following format: jdbc:hive2://datahub1-master0.geo-1035.lskx-pvue.a4.cloudera.site/;ssl=true;transportMode=http;httpPath=datahub1/cdp-proxy-api/hive Majorly we need to furnish the following information in the appropriate fields: Host(s) : datahub1-master0.geo-1035.lskx-pvue.a4.cloudera.site Port : 443 Authentication Mechanism : Username/Password Thrift Transport : HTTP Go to HTTP Options : HTTP Path : datahub1/cdp-proxy-api/hive (you will get this info from the Hive Endpoint) Go to SSL Options: 6.1. Check Enable SSL 6.2. Check Allow Self-signed Server Certificate check box 6.3. Trusted Certificates: Select the path to the PEM file containing the root ca cert of the Knox gateway. Note: You can download the TLS Public Certificate from Data Hub > Token Integration > TLS Public Certificate > Download the PEM file. Save and Test Connection.
... View more
04-01-2024
02:38 AM
1 Kudo
@Choolake, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.
... View more
04-01-2024
02:36 AM
1 Kudo
@frbelotto, @ZainK Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.
... View more
03-29-2024
10:29 PM
1 Kudo
@Scharan Thanks! I figured out the issue, following properties were not configured in hive-site hive.server2.authentication.spnego.keytab hive.server2.authentication.spnego.principal
... View more
03-28-2024
09:51 AM
1 Kudo
@hegdemahendra You may try Cloudera Hive JDBC Driver. The driver class name would be "com.cloudera.hive.jdbc.HS2Driver".
... View more
03-18-2024
02:56 PM
3 Kudos
@yashwanth Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks.
... View more
03-14-2024
11:58 PM
1 Kudo
Hive does use stats from an external table in preparing query plan. When stats are accurate, it could estimate the size of intermediate data sets and select efficient join strategies. The only thing I noticed is the fetch task is not working.
... View more