sas access to hadoop error

Go — Fri, 20 Apr 2018 19:03:20 GMT

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.

Re: sas access to hadoop error

maheshtalla — Fri, 20 Apr 2018 19:10:00 GMT

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.

topic sas access to hadoop error in Administration and Deployment

sas access to hadoop error

Re: sas access to hadoop error