Unable to execute Hadoop query

Reply
Occasional Contributor
Posts: 11

Unable to execute Hadoop query

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

Occasional Contributor
Posts: 11

Re: Unable to execute Hadoop query

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

Senior User
Posts: 1

Re: Unable to execute Hadoop query

Set your java_home path. It will solve your issue.

Trusted Advisor
Posts: 1,519

Re: Unable to execute Hadoop query

ERROR: Table exist check error.

 

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

 

Can you query the table in hadoop?

Ask a Question
Discussion stats
  • 3 replies
  • 742 views
  • 0 likes
  • 3 in conversation