ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Mashenkov <andrey.mashen...@gmail.com>
Subject Re: INSERT into SELECT from Ignite 1.9 or 2.0
Date Mon, 18 Sep 2017 13:09:31 GMT
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 <adam.the.hammer@gmail.com> 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

Mime
View raw message