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: Join with subquery in 1.9 or 2.0
Date Wed, 20 Sep 2017 10:41:11 GMT
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.hammer@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

Mime
View raw message