Skip to Content
avatar image
Former Member

Change port number for SDI Hive adapter?

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:


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??



Add comment
10|10000 characters needed characters exceeded

  • 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 ?


  • Get RSS Feed

1 Answer

  • Jan 23, 2017 at 06:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded