Error is coming while writing where Condition in Hive database

[swatitomar]

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'.

[NitinK7]

can you paste here your error script as well

[swatitomar]

Please check 

[NitinK7]

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

where mdm_id='1122155'  limit 10000;