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
... View more