Apache Hive adapter connection fails
Article ID: KB0070099
Updated On:
| Products | Versions |
|---|---|
| ibi WebFOCUS | 8207.28 and above. |
Description
While trying to test or configure the Apache Hive adapter, one can expect an error: SQLCODE IS 500168. Below is a detailed error, which is not letting the adapter to get configured.
SQLCODE IS 500168 (HEX: 0007A1C8) XOPEN: HY000
(500168) [HY000] [Cloudera] {HiveJDBCDriver}(500168)
Error creating login context using ticket cache: unable to obtain service principal name for authentication.
Below is the screenshot for reference:
SQLCODE IS 500168 (HEX: 0007A1C8) XOPEN: HY000
(500168) [HY000] [Cloudera] {HiveJDBCDriver}(500168)
Error creating login context using ticket cache: unable to obtain service principal name for authentication.
Below is the screenshot for reference:
Issue/Introduction
While trying to test or configure the Apache Hive adapter, one can observe the following error: SQLCODE IS 500168.
Environment
Windows. Linux
Resolution
To resolve the issue, one can check if the below statement is present in edasprof.prf:
ENGINE SQLHIV SET ENABLE_KERBEROS ON
If the above statement is not there in the edasprof.prf, then one can add the same and restart the Reporting Server. This will fix the issue.
ENGINE SQLHIV SET ENABLE_KERBEROS ON
If the above statement is not there in the edasprof.prf, then one can add the same and restart the Reporting Server. This will fix the issue.
Feedback
Yes
No
Powered by
