topic Re: SAS/Hadoop (Hortonworks) Hive connection issue in SAS Data Management

SAS/Hadoop (Hortonworks) Hive connection issue

fatcat — Wed, 28 Oct 2015 18:16:43 GMT

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

Re: SAS/Hadoop (Hortonworks) Hive connection issue

JBailey — Wed, 28 Oct 2015 18:25:00 GMT

Hi Alex,

Are these the only messages displaying in your SAS log?

Best wishes,

Jeff

Re: SAS/Hadoop (Hortonworks) Hive connection issue

fatcat — Wed, 28 Oct 2015 18:37:34 GMT

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

Re: SAS/Hadoop (Hortonworks) Hive connection issue

JBailey — Wed, 28 Oct 2015 19:13:40 GMT

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

Re: SAS/Hadoop (Hortonworks) Hive connection issue

fatcat — Fri, 20 Nov 2015 16:50:18 GMT

Thanks Jeff. SAS TS is working on it.