Hello! Have you tried instead: MERGE INTO RBCFPVP.RBCFPVPDATAIN (valuationdate, BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,_key) SELECT valuationdate, BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,'12-03-2019_5_99999' AS _KEY FROM RBCCTEVAPVP.RBCCTEVAMARGINCALCED ;
This without VALUES (). Works for me for simpler tables. Regards, -- Ilya Kasnacheev ср, 3 июл. 2019 г. в 19:07, vitalys <vitaly.seliva...@prudential.com>: > KEY clause is commented out and not being used : > > 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 still fails with the message posted above > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
