BookmarkSubscribeRSS Feed
Go
Quartz | Level 8 Go
Quartz | Level 8

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.

1 REPLY 1
maheshtalla
Quartz | Level 8

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. 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1291 views
  • 0 likes
  • 2 in conversation