Join with subquery in 1.9 or 2.0

[acet]

Hello,
I was looking to do something similar to:

SELECT a.customerid, h.name, h.address 
FROM 
"customer_cache".CUSTOMER as a
JOIN
(select min(id) as id, name, address, cust_id from "second_cache".DETAILS
group by name, address, cust_id) as h on a.customerid = h.cust_id

This seems to work fine in the debug console but when trying it with ignite
I get:

javax.cache.CacheException: class org.apache.ignite.IgniteException:
org.apache.ignite.internal.processors.query.h2.sql.GridSqlJoin cannot be
cast to org.apache.ignite.internal.processors.query.h2.sql.GridSqlAlias


Is there any way to achieve this?
Thanks



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

INSERT into SELECT from Ignite 1.9 or 2.0

[acet]

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/