I had some issue with the MERGE .. SELECT ..
*MERGE INTO RBCFPVP.RBCFPVPDATAIN (valuationdate,
BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,_key)
VALUES (SELECT valuationdate,
BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,'12-03-2019_5_99999'
AS _KEY FROM RBCCTEVAPVP.RBCCTEVAMARGINCALCED );*
That doesn't work and produces this error :
/MERGE INTO RBCFPVP.RBCFPVPDATAIN (valuationdate,
BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,_key)
--KEY (VALUATIONDATE,businessrun,reportingcompany)
--VALUES ('12-03-2019','5',99999,3.3,4.4,5.5,6.6,7.7,'12-03-2019_5_99999');
VALUES (SELECT valuationdate,
BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,'12-03-2019_5_99999'
AS _KEY FROM RBCCTEVAPVP.RBCCTEVAMARGINCALCED );
SELECT valuationdate,
BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,'12-03-2019_5_99999'
AS _key FROM RBCCTEVAPVP.RBCCTEVAMARGINCALCED /
however, If I hard-code the values everything works fine :
MERGE INTO RBCFPVP.RBCFPVPDATAIN (valuationdate,
BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,_key)
VALUES ('12-03-2019','5',99999,3.3,4.4,5.5,6.6,7.7,'12-03-2019_5_99999');
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
