Skip to Content
1
Former Member
Jan 12, 2017 at 01:41 AM

Change port number for SDI Hive adapter?

183 Views

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.