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/
