Hello! Can you please quote full stack traces? They are probably in the logs of server nodes.
Regards, -- Ilya Kasnacheev вт, 2 июл. 2019 г. в 23:25, vitalys <[email protected]>: > I am running Ignite v.25 and I am trying to populate cache using SQL > statements via DBeaver. > > I create a cache called TAXRATE with the following object structure : > > SCENARIO VARCHAR > VALUEDATE VARCHAR > ENTITY VARCHAR > PRODUCTGROUP VARCHAR > YEAR INTEGER > AMOUNT DOUBLE > KEY VARCHAR > > Here is an INSERT statement I run : > > *INSERT INTO TAXRATE.TAXRATE > VALUES ('SCENARIO','12-03-2019','5','99999',2019,3.3,'mykey');* > > and I am getting an error : > > /SQL Error [1] [50000]: Failed to execute DML statement [stmt=INSERT INTO > TAXRATE.TAXRATE > VALUES ('SCENARIO','12-03-2019','5','99999',2019,3.3,'mykey'), > params=null]/ > > Here is an MERGE statement : > > *MERGE INTO TAXRATE.TAXRATE (scenario, > VALUEDATE,ENTITY,PRODUCTGROUP,"YEAR",AMOUNT,"KEY") > --KEY (VALUATIONDATE) > VALUES ('SCENARIO','12-03-2019','5','99999',2019,3.3,'mykey');* > > and here is the same error I am getting : > > /SQL Error [1] [50000]: Failed to execute DML statement [stmt=MERGE INTO > TAXRATE.TAXRATE (scenario, > VALUEDATE,ENTITY,PRODUCTGROUP,"YEAR",AMOUNT,"KEY") > --KEY (VALUATIONDATE) > VALUES ('SCENARIO','12-03-2019','5','99999',2019,3.3,'mykey'), > params=null]/ > > > Is there any way to populate the cache using SQL INSERT and/or MERGE? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
