Hi, Looks like a bug.
Would you please share a full stacktrace and a reproducer if possible? You can try to rewrite query without join to smth like this: Select .. from A, B Where A.id = B.id; On Mon, Sep 18, 2017 at 7:36 PM, acet <adam.the.ham...@gmail.com> wrote: > 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/ > -- Best regards, Andrey V. Mashenkov