Re: Issue in Distributed joins

Hello! Since there's no immediate response, I have filed a ticket: https://issues.apache.org/jira/browse/IGNITE-12984 Regards, -- Ilya Kasnacheev пн, 20 апр. 2020 г. в 18:38, DS : > Hello, Any update on this from SQL people? > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble

Re: Issue in Distributed joins

Hello, Any update on this from SQL people? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Issue in Distributed joins

Hello! Apache Ignite has known limitations on the use of distributed SQL, namely that there is just one reduce phase. I'm not actually sure whether you have hit this exact one using this query. Let's wait on feedback from SQL people (who are probably busy with their Calcite affair), but of course

Re: Issue in Distributed joins

Hello again! Having one table as replicated and other as partitioned works already. Can you please file a defect for why nested joins are not working in the distributed mode as claimed. Regards Deepika Singh -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Issue in Distributed joins

Hello! Bad news is that I can't say what went wrong here. Maybe people more familiar with our SQL engine will chime in. Good news is, I have a work-around. It is obvious in your case that blood_group_info is a reference table (i.e. a small constant-size table instead of data table). I recommend s

Re: Issue in Distributed joins

Hello Ilya, Please find the script in the attachment. The file also contains the query to run in comments. Also, *we have enabled non-collocated joins check. * forDistributedJoins.sql Regards Deepika Singh

Re: Issue in Distributed joins

Hello Ilya, Sure I'll do that Regards Deepika -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Issue in Distributed joins

Hello again! You can also frame it in the form of SQL script (DDL - INSERTs - SELECTs) if you wish. Regards, -- Ilya Kasnacheev вт, 10 мар. 2020 г. в 14:30, Ilya Kasnacheev : > Hello! > > Can you please produce a small reproducer project which will, when > started, bring up a node, populate i

Re: Issue in Distributed joins

Hello! Can you please produce a small reproducer project which will, when started, bring up a node, populate it with some data and then run those queries? We will surely check. Regards, -- Ilya Kasnacheev пн, 9 мар. 2020 г. в 09:01, DS : > Hello, > I'll appreciate, if you can find time to lo

Re: Issue in Distributed joins

Hello, I'll appreciate, if you can find time to look into the issue. Regards -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Issue in Distributed joins

Hi, Kindly follow the PDF to track the observations made on distributed joins. Issue_with_Distributed_joins.pdf Regards Deepika -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/