on 01-12-2017 1:41 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.