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'.
can you paste here your error script as well
Please try once using LIMIT 10000 after where condition instead of first 10000 like below
where mdm_id='1122155' limit 10000;