Hello, Andrey, I believe you're wrong. INSERT from SELECT should work. AUTO INCREMENT columns indeed are not supported for now though, it's true.
- Alex 2017-09-18 16:09 GMT+03:00 Andrey Mashenkov <[email protected]>: > Hi, > > Auto-increment fields are not supported yet. Here is a ticket for this [1] > and you can track it's state. > Moreover, underlying H2 doesn't support SELECT with JOINs nested into > INSERT\UPDATE query. > > [1] https://issues.apache.org/jira/browse/IGNITE-5625 > > On Mon, Sep 18, 2017 at 12:31 PM, acet <[email protected]> wrote: >> >> Hello, >> I would like to insert the result of a select query into a cache in >> ignite. >> Something like: >> >> INSERT INTO "new_cache_name".NewCacheDataType(ID, CUSTOMERID, PRODUCTNAME) >> (SELECT {?}, c.id, p.product_name >> FROM "customers".CUSTOMER as c >> JOIN "products".PRODUCT as p >> ON c.id = p.customer_id) >> >> in the place of the {?} i would like to put in something similar to >> AtomicSequence, however seeing as this will be work done without using the >> client I cannot tell how this is possible. >> Can someone advise if this can be done, and if so, how? >> >> Thanks. >> >> >> >> -- >> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ > > > > > -- > Best regards, > Andrey V. Mashenkov
