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.
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.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
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.