SAS/ACCESS for Hadoop, connection failure after SSL enabled

Reply
Senior User
Posts: 1

SAS/ACCESS for Hadoop, connection failure after SSL enabled

I have couple questions:

Does SAS/ACCESS (94M2) supporting SSL to Hive ?

After Hadoop enabled SSL, SAS Hive connections are failure with following error:

 

ERROR: java.sql.SQLException: Could not open client transport with JDBC Uri:
       jdbc:hive2://xxxyyy:10000/user_db;principal=hive/_HOST@SSSSS.ORG: Invalid status 21
ERROR: Unable to connect to the Hive server.
ERROR: Error trying to establish connection.

 

Where i supposed to add ssl=True and sslTrustStore from SAS/Access?

 

Thanks,

Scott

 

SAS Employee
Posts: 198

Re: SAS/ACCESS for Hadoop, connection failure after SSL enabled

Hi @nozh,

 

SAS 9.4M2 does support using SSL and Hive.

 

Which Hadoop distribution (include version number) are you trying to connect to? Can you include the code for your LIBNAME statement? The URI= option is required, I think, for the connection. Here is an example:

 

libname hdplib hadoop uri="jdbc:hive2://some.cool.name:10000/;ssl=true;sslTrustStore=/sas/as/hadoop/truststore.jks;sslTrustStorePassword=passw0rd" server="some.cool.name" port=10000 subprotocol=hive2;

 

As a general rule, SAS/ACCESS Interface to Hadoop does not provide a great deal of detail when it encounters connection issues. It may help to try PROC HADOOP. It usually provides more detailed evidence as to the cause of issues.  

 

Best wishes,

Jeff

Ask a Question
Discussion stats
  • 1 reply
  • 267 views
  • 0 likes
  • 2 in conversation