Hi there, i'm trying to connect my cdh hadoop with SAS. I thought all configuration is done (SAS_HADOOP_CONFIG_PATH & SAS_HADOOP_JAR_PATH, Java heap space something), but i still got error.(My SAS version: 9.4, CDH: 4.7.1 with hbase1, hdfs1, hive1, hue1, impala1, mapreduce1, oozie1, sqoop1, zookeeper1)
my log is here:
1 libname myhive hadoop subprotocol=hive
2 port=10000
3 host="192.168.174.101"
4 schema="default"
5 user="admin"
6 password=XXXXXXX
7 ;
ERROR: java.sql.SQLException: Could not establish connection to 192.168.174.101:10000/default :java.net .ConnectException: Connection refused: connect
ERROR: Error trying to establish connection.
ERROR: Error in the LIBNAME statement.
And i also tried port 7180(my chd manager port):
2 libname myhive hadoop subprotocol=hive
3 port=7180
4 host="192.168.174.101"
5 schema="default"
6 user="admin"
7 password=XXXXXXX
8 ;
ERROR: java.sql.SQLException: org.apache.thrift.transport.TTransportException
ERROR: Error trying to establish connection.
Actually i consider this error have something to do with the crendentials, because i have tried to use the sas deployment manager to configure it, it created:
But account name& password definitely not wrong because it was default of CDH: admin&admin, and i also can logon CDH manager with it.
What's wrong?
Here's my JAR file
Many thanks!!!!!
Hi Karas,
Here are a couple of community threads that may help:
Best,
Anna
Thanks to Anna, but still no luck found here..
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.