sas access to hadoop error

[Go]

Hi All,

We are trying to SAS/Access to hadoop with below libname and I get below error ? any thoughts? (hadoop jar/conf path looks all good)

libname hdp hadoop server='ixnbda1dm04.sce.com' port=10000 schema=default subprotocol=hive2;

ERROR: Error trying to establish connection: Could not open client transport with JDBC Uri:

       jdbc:hive2://IYXCDBDA04.sce.com:10000/default: java.net.ConnectException: Connection refused (Connection refused)

ERROR: Error in the LIBNAME statement.

[maheshtalla]

Hi,

From the error I believe its port issue. Can you check and confirm if Hive is configured to same port 10000 and you have opened firewall from SAS to Hadoop environment.