04-20-2018 03:03 PM
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.
04-20-2018 03:10 PM
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.