SAP Knowledge Base Article - Preview

2708105 - Hive Remote Source Configuration does not work after upgrade to Hive 2.x.x - SAP Cloud Platform BDS

Symptom

  • After upgrading Apache Hive from 1.2.1 to 2.3.3 on SAP Cloud Platform Big Data Services, connecting a remote source using SDI Hive adapter does not work anymore
  • Depending on the connection settings (port=10000 or port=10010 or port=20000 or port=20010 or Hive Version=2.1.1 or Hive Version=2.3.3) for the remote source, you may receive one of below errors:

(Catalog) Error reading Remote Object: InternalError: dberror(CallableStatement.execute): 403 - internal error: Cannot get remote source objects: Cannot establish JDBC connection. Error: Could not open client transport with JDBC Uri: jdbc:hive2://hiveserver-<clientname>.s3s.altiscale.com:10010/<database_name>: Invalid status 21

(Catalog) Error reading Remote Object: InternalError: dberror(CallableStatement.execute): 403 - internal error: Cannot get remote source objects: Cannot establish JDBC connection. Error: Could not open client transport with JDBC Uri: jdbc:hive2://hiveserver-<clientname>.s3s.altiscale.com:20010/<database_name>: java.net.ConnectException: errno: 111 (Connection refused), error: Connection refused (local port 50304 to address 0:0:0:0:0:0:0:0, remote port 20010 to address 10.244.16.19 (hiveserver-<clientname>.s3s.altiscale.com))

(Catalog) Error reading Remote Object: InternalError: dberror(CallableStatement.execute): 403 - internal error: Cannot get remote source objects: Cannot establish JDBC connection. Error: Could not open client transport with JDBC Uri: jdbc:hive2://hiveserver-<clientname>.s3s.altiscale.com:20000/<database_name>: java.net.ConnectException: errno: 111 (Connection refused), error: Connection refused (local port 56102 to address 0:0:0:0:0:0:0:0, remote port 20000 to address 10.244.16.19 (hiveserver-<clientname>.s3s.altiscale.com))

(Catalog) Error reading Remote Object: InternalError: dberror(CallableStatement.execute): 403 - internal error: Cannot get remote source objects: Cannot establish JDBC connection. Error: Could not open client transport with JDBC Uri: jdbc:hive2://hiveserver-<clientname>.s3s.altiscale.com:10000/<database_name>: Peer indicated failure: Unsupported mechanism type PLAIN

(Catalog) Error reading Remote Object: InternalError: dberror(CallableStatement.execute): 403 - internal error: Cannot get remote source objects: No Hive stand-alone JDBC JAR files found with version 2.1.1

(Catalog) Error reading Remote Object: InternalError: dberror(CallableStatement.execute): 403 - internal error: Cannot get remote source objects: No Hive stand-alone JDBC JAR files found with version 2.3.3


Read more...

Environment

  • SAP Cloud Platform Big Data Services (BDS) 4.3
  • SAP Cloud Platform Big Data Services (BDS) 5.0

Product

SAP Cloud Platform Big Data Services 1711 ; SAP Cloud Platform Big Data Services all versions

Keywords

Altiscale, hive, sdi, hana , KBA , BC-NEO-BDS , HCP Big Data Service , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.