You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2018/07/27 12:24:00 UTC
[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&focusedCommentId=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)