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?
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.