Description
LINQ IN clause is implemented in IGNITE-4425 and maps from ICollection.Contains.
However, IN has some limitations in Ignite, and better alternative is temporary table join:
https://apacheignite.readme.io/docs/sql-performance-and-debugging#sql-performance-and-usability-considerations
Example SQL:
new SqlFieldsQuery("select p.name from Person p join table(id bigint = ?) i on p.OrgId = i.id", new object[] { new object[] {1,3}})
Add support in LINQ like this:
persons.AsCacheQueryable().Join(new[] {1, 3}, p => p.Value.OrgId, x => x, (p, x) => p);
Attachments
Issue Links
- is related to
-
IGNITE-5404 SQL temp table join does not work with typed arrays
-
- Open
-
- links to
