Re: Incorrect map query built when joining with a subquery with group by statement

2017-11-13 Thread alin-corodescu
Following up on the previous discussion, I have filed an issue regarding the problem : https://issues.apache.org/jira/browse/IGNITE-6865 I have found a workaround this issue by using FROM (select * from Persons) instead of FROM Persons directly, which seems like a bug, because the 2 queries should

Re: Incorrect map query built when joining with a subquery with group by statement

2017-10-30 Thread alin-corodescu
Thank you for your response, I will look further into the problem and see if I can find any workarounds. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Incorrect map query built when joining with a subquery with group by statement

2017-10-27 Thread Andrey Mashenkov
Hi Alin, Ignite have no support for non-collocated subqueries [1] [2], here is a ticket [3]. Try to set collocated flag to true [4] to hint Ignite your query is collocated. [1] http://apache-ignite-users.70518.x6.nabble.com/Does-Ignite-support-nested-SQL-Queries-td1714.html [2] http://apache-ign

Incorrect map query built when joining with a subquery with group by statement

2017-10-27 Thread alin-corodescu
Hello, While experimenting around with Ignite, I came across a bug regarding the map query building. (the queries that run on each individual node). Consider the following dummy query (this is a reproduction of the error I found while testing actual production queries): SELECT t1.name, count(1) F