09-01-2014 10:00 AM
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:{})
09-01-2014 02:01 PM
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/";
09-01-2014 02:01 PM
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/";
Need further help from the community? Please ask a new question.