Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
swatitomar
Creator
Creator

Error is coming while writing where Condition in Hive database

Hi Team,

I have connected with Hive Database and whenever i'm writing where condition, getting below error 

******FROM HIVE.$(vHIVE_db).`prty_dtl` where lgcl_dlt_ind='N';

working fine with SQL but not with Hive. I have to write where condition in some other way?

 

The following error occurred:
Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 35, ErrorMsg: [Hortonworks][Hardy] (35) Error from server: error code: '1' error message: 'Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask'.

 

 

Labels (1)
3 Replies
NitinK7
Specialist
Specialist

can you paste here your error script as well

swatitomar
Creator
Creator
Author

swatitomar_0-1594138267568.png

Please check 

NitinK7
Specialist
Specialist

Please try once using LIMIT 10000 after where condition instead of first 10000 like below

where mdm_id='1122155'  limit 10000;