SAS/Hadoop (Hortonworks) Hive connection issue

[fatcat]

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

[JBailey]

Hi Alex,

Are these the only messages displaying in your SAS log?

Best wishes,

Jeff

[fatcat]

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";

[JBailey]

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

[fatcat]

Thanks Jeff. SAS TS is working on it.