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

SAS/Hadoop (Hortonworks) Hive connection issue

Reply
Contributor
Posts: 41

SAS/Hadoop (Hortonworks) Hive connection issue

Hi, i am trying to connect to Hortonworks with SAS/Access for Hadoop. Able to get the klist, and able to ssh from the SAS Client machine to the one of the nodes. But getting an error when trying to connect via SAS EG. Any idea?

 

 

libname zhdplib  hadoop subprotocol='hive2' server='myserver'   schema=myschema; user='user123' pwd='Test123';

 

 

ERROR: Unable to connect to the Hive server.
ERROR: Error trying to establish connection.
ERROR: Error in the LIBNAME statement.

 

Alex

SAS Employee
Posts: 203

Re: SAS/Hadoop (Hortonworks) Hive connection issue

Hi Alex,

 

Are these the only messages displaying in your SAS log?

 

Best wishes,

Jeff

Contributor
Posts: 41

Re: SAS/Hadoop (Hortonworks) Hive connection issue

Hi Jeff, yes those are the only errors i get when i submit the libname from SAS EG. I have explicitly set the config/jar paths also like so:

 

options set=SAS_HADOOP_CONFIG_PATH="/sashome/hadoopConfigFiles";
options set=SAS_HADOOP_JAR_PATH="/sashome/hadoopJarFiles";

SAS Employee
Posts: 203

Re: SAS/Hadoop (Hortonworks) Hive connection issue

Hi Alex,

 

This is most likely a configuration issue - typically missing JARs or config files. I experience this problem about twice every month. Since you are using Kerberos finding the cause of your issue could be difficult to do via the SAS Communities. The best way to proceed is to contact SAS Tech Support. They will take a look at your configuration (JARs and XML config files) and may have you run standalone connection programs that will help determine if the problem is with the SAS or Keberos configuration.

 

Here is the link for reporting problems.
http://support.sas.com/ctx/supportform//createForm

 

Take a look at the SAS 9.4 Hadoop Configuration Guide (I am assuming you are using SAS 9.4). It will help you when discussing your issues with SAS Tech Support.

 

Let me know if I can help in any way. Good luck!

 

Best wishes,
Jeff

 

Contributor
Posts: 41

Re: SAS/Hadoop (Hortonworks) Hive connection issue

Thanks Jeff. SAS TS is working on it. 

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