General SAS Programming

[Manu_SAS]

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(statusCodeUCCESS_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:{})

[Manu_SAS · Accepted solution]

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

[Manu_SAS · Accepted solution]

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