My Oracle Support Banner

On Oracle Big Data Appliance, after Upgrade to CDH 5.5.1/BDA 4.4, HiveServer, Httpfs, Webhdfs, and Beeline Tests Fail (Doc ID 2112976.1)

Last updated on DECEMBER 26, 2019

Applies to:

Big Data Appliance Integrated Software - Version 4.4.0 and later
Linux x86-64

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner. 

On Oracle Big Data Appliance after upgrade to CDH 5.5.1/BDA 4.4, HiveServer, Httpfs, Webhdfs, and command line beeline tests Fail. Also Hue throws an error about not being able to access Hive Server2.

Logging in HUE as admin user shows a configuration error that HS2 is not available.



Beeline test with default Apache Jdbc driver

beeline> !connect jdbc:hive2://bdanode04:10000/default;principal=hive/bdanode04@<REALM>
scan complete in 2ms
Connecting to j jdbc:hive2://bdanode04:10000/default;principal=hive/bdanode04@<REALM>
Enter username for  jdbc:hive2://bdanode04:10000/default;principal=hive/bdanode04@<REALM>:
Enter password for  jdbc:hive2://bdanode04:10000/default;principal=hive/bdanode04@<REALM>:
Error: Could not open client transport with JDBC Uri:  jdbc:hive2://bdanode04:10000/default;principal=hive/bdanode04@<REALM>: Invalid status 21 (state=08S01,code=0)
0: jdbc:hive2://bdanode04:10000/default (closed)>

  
Beeline test with Cloudera Jdbc driver

Connecting to jdbc:hive2://bdanode04.example.com:10000/default;AuthMech=1;KrbRealm=<REALM>;KrbHostFQDN=bdanode04.example.com.com;KrbServiceName=hive;SSL=1;SSLTrustStore=/opt/cloudera/security/**/ca-certs.jks;SSLTrustStorePwd=<TRUSTSTORE_PASSWORD>
Error: Could not open client transport with JDBC Uri: jdbc:hive2://bdanode04.example.com:10000/default;AuthMech=1;KrbRealm=<REALM>;KrbHostFQDN=bdanode04.example.com;KrbServiceName=hive;SSL=1;SSLTrustStore=/opt/cloudera/security/**/ca-certs.jks;SSLTrustStorePwd=<TRUSTSTORE_PASSWORD>: Invalid status 21 (state=08S01,code=0)
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://bdanode04.example.com:10000/default;AuthMech=1;KrbRealm=<REALM>;KrbHostFQDN=bdanode04.example.com;KrbServiceName=hive;SSL=1;SSLTrustStore=/opt/cloudera/security/**/ca-certs.jks;SSLTrustStorePwd=<TRUSTSTORE_PASSWORD>:
Invalid status 21
     at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:221)
     at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:167)
     at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
     at java.sql.DriverManager.getConnection(DriverManager.java:664)
     at java.sql.DriverManager.getConnection(DriverManager.java:208)
     at org.apache.hive.beeline.DatabaseConnection.connect(DatabaseConnection.java:137)
     at org.apache.hive.beeline.DatabaseConnection.getConnection(DatabaseConnection.java:178)

  

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.