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 OCTOBER 11, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms