[jira] [Commented] (IGNITE-8009) SQL local query to a cache with queryParallelism>1 doesn't use index
[ https://issues.apache.org/jira/browse/IGNITE-8009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16559670#comment-16559670 ] Vladimir Ozerov commented on IGNITE-8009: - [~amashenkov], [~pvinokurov], Join order is enforced for map part of all two-step queries. There is nothing wrong with parallelism here. If you get this result with parallelism, you will get the same result without it when there are several nodes. > SQL local query to a cache with queryParallelism>1 doesn't use index > - > > Key: IGNITE-8009 > URL: https://issues.apache.org/jira/browse/IGNITE-8009 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.3, 2.4 >Reporter: Pavel Vinokurov >Priority: Major > Attachments: ExplainAndIndexReproducer.java > > > queryParallelism>1 + setLocal(true) changes the query plan and exclude usage > of the sql index. > Explain query with setLocal(false) and queryParallelism=1 : > SELECT > T__Z0.ID AS __C0_0 > FROM TABLE(COL VARCHAR='name0') I__Z1 > /* function */ > INNER JOIN PUBLIC.PERSON T__Z0 > /* PUBLIC.PERSON_NAME: NAME = I__Z1.COL */ > ON 1=1 > WHERE (T__Z0.SOURNAME = 'sourname0') > AND (T__Z0.NAME = I__Z1.COL) > Explain query with setLocal(true) and queryParallelism=2 : > SELECT > T__Z1.ID AS __C0_0 > FROM PUBLIC.PERSON T__Z1 > /* PUBLIC.PERSON.__SCAN_ */ > /* WHERE T__Z1.SOURNAME = 'sourname0' > */ > INNER JOIN TABLE(COL VARCHAR='name0') I__Z0 > /* function: COL = T__Z1.NAME */ > ON 1=1 > WHERE (T__Z1.SOURNAME = 'sourname0') > AND (T__Z1.NAME = I__Z0.COL) -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-8009) SQL local query to a cache with queryParallelism>1 doesn't use index
[ https://issues.apache.org/jira/browse/IGNITE-8009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1649#comment-1649 ] Andrew Mashenkov commented on IGNITE-8009: -- Looks like GridReduceQueryExecutor always force join order flag for map queries in query() method. > SQL local query to a cache with queryParallelism>1 doesn't use index > - > > Key: IGNITE-8009 > URL: https://issues.apache.org/jira/browse/IGNITE-8009 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.3, 2.4 >Reporter: Pavel Vinokurov >Priority: Major > Attachments: ExplainAndIndexReproducer.java > > > queryParallelism>1 + setLocal(true) changes the query plan and exclude usage > of the sql index. > Explain query with setLocal(false) and queryParallelism=1 : > SELECT > T__Z0.ID AS __C0_0 > FROM TABLE(COL VARCHAR='name0') I__Z1 > /* function */ > INNER JOIN PUBLIC.PERSON T__Z0 > /* PUBLIC.PERSON_NAME: NAME = I__Z1.COL */ > ON 1=1 > WHERE (T__Z0.SOURNAME = 'sourname0') > AND (T__Z0.NAME = I__Z1.COL) > Explain query with setLocal(true) and queryParallelism=2 : > SELECT > T__Z1.ID AS __C0_0 > FROM PUBLIC.PERSON T__Z1 > /* PUBLIC.PERSON.__SCAN_ */ > /* WHERE T__Z1.SOURNAME = 'sourname0' > */ > INNER JOIN TABLE(COL VARCHAR='name0') I__Z0 > /* function: COL = T__Z1.NAME */ > ON 1=1 > WHERE (T__Z1.SOURNAME = 'sourname0') > AND (T__Z1.NAME = I__Z0.COL) -- This message was sent by Atlassian JIRA (v7.6.3#76005)