SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS connect to CDH hadoop issue

Reply
New Contributor
Posts: 2

SAS connect to CDH hadoop issue

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:

20170726174433.jpg

 

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

20170726175222.png

 

Many thanks!!!!!

Community Manager
Posts: 486

Re: SAS connect to CDH hadoop issue

Hi Karas,

 

Here are a couple of community threads that may help:

 

Error: SAS Map reduce job using CDH VM 5.8

 

Hadoop connectivity issues

 

Best,

Anna

New Contributor
Posts: 2

Re: SAS connect to CDH hadoop issue

Thanks to Anna, but still no luck found here..

Ask a Question
Discussion stats
  • 2 replies
  • 212 views
  • 0 likes
  • 2 in conversation