Re: SQLLine: Insert into for complex object not working

2019-04-02 Thread Ilya Kasnacheev
Hello! Can you show your table config, SELECT *? Regards, -- Ilya Kasnacheev вт, 2 апр. 2019 г. в 12:46, ashishb888 : > INSERT INTO "SCHEMA".CACHE VALUES (101,31,11,null,'B','B','C','D'); // > Inserted > INSERT INTO "SCHEMA".CACHE VALUES (101,3,1,null,'B','B','C','D'); // Gave > error > > Fir

Re: SQLLine: Insert into for complex object not working

2019-04-02 Thread ashishb888
INSERT INTO "SCHEMA".CACHE VALUES (101,31,11,null,'B','B','C','D'); // Inserted INSERT INTO "SCHEMA".CACHE VALUES (101,3,1,null,'B','B','C','D'); // Gave error First 3 fields are part of the key. Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SQLLine: Insert into for complex object not working

2019-04-02 Thread Ilya Kasnacheev
Hello! It is also possible that something goes wrong with your column-field mapping, so first entry is added with (null, null, null), and the second one fails at adding the same. Can you show your sqlline output when doing so? Regards, -- Ilya Kasnacheev вт, 2 апр. 2019 г. в 10:43, ashishb888

Re: SQLLine: Insert into for complex object not working

2019-04-02 Thread Evgenii Zhuravlev
Hi, Looks like you're trying to insert the entry with the same key as before. SQL INSERT command doesn't allow to do that(in all DBs). Looks like you need to use UPDATE or UPSERT commands Evgenii вт, 2 апр. 2019 г. в 10:43, ashishb888 : > I have a cache, with complex key (3 fields). I am able g