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/