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?
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.