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 JULY 01, 2018

Applies to:

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

Symptoms

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/bda1node04@<RealmName>
scan complete in 2ms
Connecting to j jdbc:hive2://bdanode04:10000/default;principal=hive/bda1node04@<RealmName>
Enter username for  jdbc:hive2://bdanode04:10000/default;principal=hive/bda1node04@<RealmName>:
Enter password for  jdbc:hive2://bdanode04:10000/default;principal=hive/bda1node04@<RealmName>:
Error: Could not open client transport with JDBC Uri:  jdbc:hive2://bdanode04:10000/default;principal=hive/bda1node04@<RealmName>: 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.***:10000/default;AuthMech=1;KrbRealm=<RealmName>;KrbHostFQDN=bdanode04.***.com;KrbServiceName=hive;SSL=1;SSLTrustStore=/opt/cloudera/security/**/ca-certs.jks;SSLTrustStorePwd=changeit
Error: Could not open client transport with JDBC Uri: jdbc:hive2://bdanode04.***.com:10000/default;AuthMech=1;KrbRealm=<RealmName>;KrbHostFQDN=bdanode04.****.com;KrbServiceName=hive;SSL=1;SSLTrustStore=/opt/cloudera/security/**/ca-certs.jks;SSLTrustStorePwd=changeit: Invalid status 21 (state=08S01,code=0)
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://bdanode04.****.com:10000/default;AuthMech=1;KrbRealm=<RealmName>;KrbHostFQDN=bdanode04.***.com;KrbServiceName=hive;SSL=1;SSLTrustStore=/opt/cloudera/security/**/ca-certs.jks;SSLTrustStorePwd=changeit:
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.