Troubleshooting
Problem
This issue can manifest when attempting to open a non-SSL connection with a Hive server instance that has SSL enabled.
This means that you may not have the server’s certificates in your truststore, or you do not have the correct parameters in your JDBC URL.
Symptom
Pipeline fails to start with HIVE_22 error
Checking the logs, there may be an Invalid status 21 error with the following stack trace.
Resolving The Problem
Make sure that you have the Hive server certificate imported in your JVM truststore.
Append the appropriate parameters to your JDBC URL to initiate an SSL connection. For example:
jdbc:hive2://hostname:10000/default;principal=hive/<host>@REALM;ssl=true
If using a custom truststore, make sure to append the following parameters:
sslTrustStore=/path/to/truststore;trustStorePassword=password
Document Location
Worldwide
[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSM7CU","label":"IBM StreamSets Data Collector"},"ARM Category":[{"code":"","label":""}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
15 March 2025
UID
ibm17186181