Hello! I think it is self-describing: VALUATIONDATE is not a key column (but value field) so it can't be used in MERGE. You can only use key columns in KEYS() I guess.
Regards, -- Ilya Kasnacheev ср, 3 июл. 2019 г. в 18:26, vitalys <[email protected]>: > 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/ >
