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(statusCode:SUCCESS_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:{})
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/";
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/";
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.