question Azure Data Factory Linked service to CDP Hive Kerberos connectivity issue in Support Questions

Azure Data Factory Linked service to CDP Hive Kerberos connectivity issue

sridharavulapat — Tue, 21 Apr 2026 07:14:45 GMT

Dear Team,

I am trying to create ADF Linked service to CDP Hive server. CDP kerberized and ssl enabled cluster.

Cloud you share the configurations like below:

{
"name": "HiveLinkedService",
"properties": {
"type": "Hive",
"typeProperties": {
"serverType": "HiveServer2",
"thriftTransportProtocol": "SASL",
"serviceDiscoveryMode": true,
"authenticationType": "UsernameAndPassword",
"httpPath": "jdbc:hive2://******;principal=hive/_HOST@******;serviceDiscoveryMode=zooKeeper;ssl=true;zooKeeperNamespace=hiveserver2",
"host" : "******",
"port" : "10000",
"allowSelfSignedServerCert" : true,
"allowHostNameCNMismatch": true,
"enableSsl": true,
"useSystemTrustStore": true,
"trustedCertPath": ".cer path file",
"zooKeeperNameSpace": "hiveserver2",
"username" : "******",
"password": {
"type": "SecureString",
"value": "******"
}
}
}
}

Re: Azure Data Factory Linked service to CDP Hive Kerberos connectivity issue

steven-matison — Mon, 08 May 2023 14:24:32 GMT

@sridharavulapat

You should be able to find the required hive values in hive-site.xml file. You can get this file from Cloudera Manager. Additionally, use Cloudera Manager to download hive drivers and get the fully qualified jdbc url.

Re: Azure Data Factory Linked service to CDP Hive Kerberos connectivity issue

sridharavulapat — Thu, 18 May 2023 12:26:42 GMT

I tested all the scenario's and its now working. Suggest workable solutions ?

Re: Azure Data Factory Linked service to CDP Hive Kerberos connectivity issue

sridharavulapat — Thu, 18 May 2023 12:33:56 GMT

I mentioned same jdbc url which i copied from hive-site configuration file only. If you have any configuration file or workaround please let me know.

Re: Azure Data Factory Linked service to CDP Hive Kerberos connectivity issue

Lsh — Thu, 24 Aug 2023 13:17:01 GMT

I'm facing the same issue with the ADF Hive connector. It would be great if you could provide your configuration details.