Architecting, installing and maintaining your SAS environment

sas access to hadoop error

Reply
Contributor Go
Contributor
Posts: 74

sas access to hadoop error

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.

Contributor
Posts: 70

Re: sas access to hadoop error

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. 

Ask a Question
Discussion stats
  • 1 reply
  • 124 views
  • 0 likes
  • 2 in conversation