Skip to Content
1

Change port number for SDI Hive adapter?

Jan 12, 2017 at 01:41 AM

75

avatar image

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.

10 |10000 characters needed characters left characters exceeded

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.

1
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Timo Wagner
Jan 23, 2017 at 06:20 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded