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
