Re: Ignite JOIN fails to return results using WHERE clause

Hi Courtney, > Is it the case that as long as the affinity key is in the join predicate that it would be a colocated JOIN This is true for cases when you have a predicate with equality by affinity keys. If a join predicate includes affinity keys eq condition then it also can have any other condit

Re: Ignite JOIN fails to return results using WHERE clause

Hi Maksim, Interesting, thanks for your reply. Okay, I misunderstood (I also thought being on a single node that it didn't matter). Is it the case that as long as the affinity key is in the join predicate that it would be a colocated JOIN (I'm concerned about the impact of setDistributedJoins(tru

Re: Ignite JOIN fails to return results using WHERE clause

Hi Courtney, > I don't expect collocation issues to be in play here Do you check this doc: https://ignite.apache.org/docs/latest/SQL/distributed-joins ? It says: "A distributed join is a SQL statement with a join clause that combines two or more partitioned tables. If the tables are joined on th

Ignite JOIN fails to return results using WHERE clause

I have a query like this: SELECT > tbl.id AS tbl_id, tbl.releaseId AS tbl_releaseId, col.type AS col_type > FROM T0 tbl > INNER JOIN T1 col ON tbl.id = col.tableId > *WHERE tbl.releaseId = ? AND tbl.name = ?* > LIMIT 100 > This returns no results so after investigating, I ended