ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Stronchinskiy (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-4636) .NET: Support local collection joins in LINQ
Date Fri, 02 Jun 2017 16:13:04 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-4636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16034967#comment-16034967
] 

Sergey Stronchinskiy commented on IGNITE-4636:
----------------------------------------------

[~ptupitsyn],

While working on this feature found that {{SqlFieldsQuery}} fails if it is passed collection
of {{int}}'s instead of {{objects}}:

{code}
employeeCache.QueryFields(new SqlFieldsQuery("select p.name, p.salary from Employee p join
table(id bigint = ?) i on p.organizationid = i.id"
    , new object[] { new [] { 1, 3 } }));
{code}

> .NET: Support local collection joins in LINQ
> --------------------------------------------
>
>                 Key: IGNITE-4636
>                 URL: https://issues.apache.org/jira/browse/IGNITE-4636
>             Project: Ignite
>          Issue Type: Improvement
>          Components: platforms
>    Affects Versions: 1.8
>            Reporter: Pavel Tupitsyn
>            Assignee: Sergey Stronchinskiy
>              Labels: .NET, LINQ
>             Fix For: 2.1
>
>
> 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:
> {code}
> new SqlFieldsQuery("select p.name from Person p join table(id bigint = ?) i on p.OrgId
= i.id", new object[] { new object[] {1,3}})
> {code}
> Add support in LINQ like this:
> {code}persons.AsCacheQueryable().Join(new[] {1, 3}, p => p.Value.OrgId, x => x,
(p, x) => p);{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message