@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

Hi, @gowthamsanjam cloudera provides its own JDBC driver to connect to the cloudera warehouse, instead of the custom jar you can go with the Cloudera-provided jar, which should suffice for your use case. ... View more

@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

That works. Thanks! ... View more

okay, that sounds like a solution to me, thanks for your help :)) ... View more

@CDH-pgrade Thank you for bringing this to our community. Q. What is the current version of CM and CDH that the cluster is on? Q. What is the primary objective of this request? Is there a business use-case we need to be aware of? 2. Does migration of CDH 4.7.2 to latest version of CDP private cloud involves multi-stage process ? (example:  First step could be migration as CDH 4.7.2 to CDH 5 (or) CDH 6 and then as second step, migrate from CDH 5/CDH 6 to CDP Indeed, this will be considered as multi-stage upgrade process. CDH 4 > CDH 5 > CDP I would highly encourage you to review the high-level in-place upgrade paths that is available from CDH5 to latest version of Cloudera Stack.[0a] [0a] https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade/topics/cdppvc-upgrade-paths.html Though this multi-stage upgrade will have lot of technicalities, Do you happen to carryout a feasibility study of deploying a fresh CDP cluster, followed by migrating your existing data/workload to this fresh CDP deployment? Let us know your thoughts. - V ... View more

@damnworld, Have the replies 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.  ... View more

jdbc:hive2://<host>:10000 Error: Could not open client transport with JDBC Uri: .... Invalid status 21 If i use just 'beeline' command, i am able to connect to hive. However if i use below command, i am getting exception. beeline -u jdbc:hive2://<host>:10000/default -n user -p pwd 23/10/23 23:22:31 [main]: WARN transport.TSaslTransport: Could not send failure response org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset 23/10/23 23:22:31 [main]: WARN jdbc.HiveConnection: Failed to connect to host:10000 log4j:ERROR Could not create an Appender. Reported error follows. java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be cast to com.cloudera.hive.jdbc42.internal.apache.log4j.Appender at com.cloudera.hive.jdbc42.internal.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:248) at com.cloudera.hive.jdbc42.internal.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:176) log4j:WARN No appenders could be found for logger (com.cloudera.hive.jdbc42.internal.apache.thrift.transport.TSaslTransport). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. Unknown HS2 problem when communicating with Thrift server. Error: Could not open client transport with JDBC Uri: jdbc:hive2://host:10000/default: Invalid status 21 Also, could not send response: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset (state=08S01,code=0)   ... View more

Hi, Can you please share example of this API call, I want to call this API for upgrade.  ... View more

the issue is resolve by adding user into dlhue group which was also present on ldap. the group is been given previleges by sentry to access hive tables. ... View more