Qlikview reload with Hive not working for group by , where clause applied on script

[NirmalaKumari]

Hi,

I am facing below error while doing qlikview reload. Can someone help on this:

ODBC error

Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 35, ErrorMsg: [Cloudera][Hardy] (35) Error from server: error code: '2' error message: 'Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask'.

SQL SELECT

field1,

field2... ,
fieldn,
recon_date

from default.TREND_SUMM WHERE recon_date > to_date('15-10-2020 00:00:00')

I am using qvd approach to load data  and variable is passed to where condition in script:

"WHERE recon_date > to_date('$(ReconLastDttm1)')"

[Brett_Bleess]

@NirmalaKumari This is NOT a Qlik issue, it is an issue with the HIVE Connector not being able to process that set of instructions, so you will need to go over to the HIVE Community to find out why that may be etc.  We are simply reporting the error we are receiving from the Connector in this case...

Regards,
Brett