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/";
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.