SAS connect to CDH hadoop issue

Karas — Wed, 26 Jul 2017 11:08:37 GMT

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!!!!!