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?
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: