topic Re: Error is coming while writing where Condition in Hive database in App Development

Error is coming while writing where Condition in Hive database

swatitomar — Sat, 16 Nov 2024 18:24:18 GMT

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

Re: Error is coming while writing where Condition in Hive database

NitinK7 — Tue, 07 Jul 2020 14:45:04 GMT

can you paste here your error script as well

Re: Error is coming while writing where Condition in Hive database

swatitomar — Tue, 07 Jul 2020 16:11:48 GMT

Please check

Re: Error is coming while writing where Condition in Hive database

NitinK7 — Wed, 08 Jul 2020 06:37:43 GMT

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

where mdm_id='1122155' limit 10000;