SAS HADOOP

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

SAS HADOOP

Hi I am getting following error while defining to hive. I have tried using java client to connect with Hive and I am able to connect with same parameters and classpath. I am not sure why I am getting error here.

libname hdplib hadoop server="xxxxxx.xx.xxxx.com" port=10000 schema=default subprotocol=hive2 user=hive;

ERROR: java.sql.SQLException: Could not establish connection to jdbc:hive2://xxxxxx.xx.xxxx..com:10000/default: Required field

       'serverProtocolVersion' is unset! Struct:TOpenSessionResp(status:TStatus(statusCodeSmiley FrustratedUCCESS_STATUS),

       serverProtocolVersion:null, sessionHandle:TSessionHandle(sessionId:THandleIdentifier(guid:E3 71 58 E3 17 1C 4F 0D AC 26 XX

       XX XX 55 E2 XX, secret:XX XX XX XX XX A8 XX 13 86 B7 A0 AA 1F E1 CF 74)), configuration:{})


Accepted Solutions
Solution
‎09-01-2014 02:01 PM
New Contributor
Posts: 2

Re: SAS HADOOP

Hi I figure out the issue. The variable SAS_HADOOP_JAR_PATH was smehow being overwritten in server in which code was submitted in GRID setup, I declared this variable as part of SAS options in top of SAS program and it works fine.

Added this line:

options set=SAS_HADOOP_JAR_PATH="/abc/def/sas_jars/";

View solution in original post


All Replies
Solution
‎09-01-2014 02:01 PM
New Contributor
Posts: 2

Re: SAS HADOOP

Hi I figure out the issue. The variable SAS_HADOOP_JAR_PATH was smehow being overwritten in server in which code was submitted in GRID setup, I declared this variable as part of SAS options in top of SAS program and it works fine.

Added this line:

options set=SAS_HADOOP_JAR_PATH="/abc/def/sas_jars/";

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 313 views
  • 0 likes
  • 1 in conversation