10-28-2015 02:16 PM
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.
10-28-2015 02:37 PM
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:
10-28-2015 03:13 PM
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.
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!