Hi,
I am able to connect to Hive using the below libname statement:
libname hdplib hadoop server='hadoop_server' user='*********' password='********' subprotocol=hive2 schema=sas_dev;
proc datasets lib=hdplib;
run;
Libref HDPLIB |
Engine HADOOP
Physical Name jdbc:hive2:/hadoop_server:10000/sas_dev
Schema/Owner sas_dev
# Name Member Type
1 CLASS_D DATA
2 EMPLOYEE DATA
3 SALARY DATA
4 UNICODE_DATA DATA
But when i try to print the datasets CLASS_D, getting the following error:
ERROR: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
ERROR: Unable to execute Hadoop query.
ERROR: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
ERROR: Unable to execute Hadoop query.
ERROR: Table exist check error.
Can anybody please help me out in identifying the issue.
Thanks in Advance,
Sangramjit
I think its a new issue and nobody yet found the solution or have any idea regarding it.
Set your java_home path. It will solve your issue.
ERROR: Table exist check error.
points to a discrepancy between the hadoop metadata and the data.
Can you query the table in hadoop?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.