[jira] [Commented] (IGNITE-8009) SQL local query to a cache with queryParallelism>1 doesn't use index

["Andrew Mashenkov (JIRA)" <ji...@apache.org>]

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

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)