Unable to execute Hadoop query

[Sangramjit]

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

[Sangramjit]

I think its a new issue and nobody yet found the solution or have any idea regarding it.

[Thambu]

Set your java_home path. It will solve your issue.

[ChrisNZ]

ERROR: Table exist check error.

points to a discrepancy between the hadoop metadata and the data.

Can you query the table in hadoop?