Re:Re: Join with subquery in 1.9 or 2.0

Hi, Your demo is different from my.Mine is an example of recursive,using "with as"function.My test demo is in the attachment.package userlist; import java.util.List; import org.apache.ignite.Ignite; import org.apache.ignite.IgniteCache; import org.apache.ignite.cache.CacheAtomicityMode;

Re: Join with subquery in 1.9 or 2.0

Hi, I can't reproduce the issue neither on 1.9 nor 2.0 nor 2.1 version. PFA repro attached. Would you please check if I've missed smth? On Wed, Sep 20, 2017 at 1:41 PM, Andrey Mashenkov < andrey.mashen...@gmail.com> wrote: > Hi, > > Looks like a bug. > > Would you please share a full

Re: Join with subquery in 1.9 or 2.0

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 wrote: > Hello, > I was looking

Join with subquery in 1.9 or 2.0

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