cancel
Showing results for 
Search instead for 
Did you mean: 

Change port number for SDI Hive adapter?

Former Member

Hi, I want to create a remote source using the SDI Hive adapter connecting to my Azure HDInsight cluster. The adapter appears to only allow port 10000, however Azure uses port 443 for JDBC access to Hive. An example Azure JDBC would be:

jdbc:hive2://CLUSTERNAME.azurehdinsight.net:443/default;ssl=true?hive.server2.transport.mode=http;hive.server2.thrift.http.path=/hive2

However, whenever you specify port 443 when creating a new remote source, it gives error:

10:52:56 (Catalog) Error reading Remote Object: InternalError: dberror(CallableStatement.execute): 403 - internal error: Cannot get remote source objects: Port is not a valid port number

Is it therefore not possible to connect HANA to Azure Hive using SDI??

Cheers,

Chris.

Former Member

If the standard adapter doesn't support a port other than 10000, is the source code for the adapter available so I can modify it using the Adapter SDK ?

Chris.

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Chris,

I've forwarded this question to the developerment and seems like we've set the limits for the supported ports to be above 1024.
This bug might be solved in a future release. For now you might need to try some workaround e.g. by tunneling the 443 port on a separate server to a supported port number. I am not familiar with the Hive setup on Azure, but maybe you can also change that to listen on a port above 1024 to use it in the SDI HiveAdapter.

Best Regards,

Timo Wagner