Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)')"
@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