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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.3, 2.4
• Component/s: sql
• Assignee: Unassigned
• Reporter: Pavel Vinokurov
• Created: 22/Mar/18 04:12
• Updated: 14/Feb/19 14:15
• Resolved: 14/Feb/19 14:15

Description

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)

Issue Links

• duplicates: IGNITE-11310 SQL: Remove special interaction between query parallelism and distributed joins