[DRILL-4086] Query hangs in planing

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Component/s: Query Planning & Optimization
• Assignee: Vova Vysotskyi
• Reporter: boris chmiel
• Created: 13/Nov/15 17:50
• Updated: 07/Aug/22 18:46
• Resolved: 07/Aug/22 18:46

Description

The query is stuck seems blocked on planning (pending)

View :

create or replace view View1 AS (
SELECT 
B1.columns[0] c0,
B1.columns[1] c1
FROM dfs.tmp.`TEST\B1.csv` B1
LEFT OUTER JOIN dfs.tmp.`TEST\BK.csv` BK
ON B1.columns[1] = BK.columns[0]
WHERE BK.columns[0] is null AND trim(B1.columns[1]) <> ''
);

create or replace view View2 AS (
SELECT 
View1.c0,
View1.c1
FROM View1
LEFT OUTER JOIN dfs.tmp.`TEST\BK.csv` BK
ON View1.c1 = BK.columns[0]
WHERE BK.columns[0] is null AND trim(View1.c1) <> ''
);

Query :

select * FROM dfs.tmp.View2 

=> Infinite Pending

data set :

B1

A;
B;F
C;A
D;E
E;
F;C

BK

A;1
B;2
F;4

Issue Links

• is fixed by: DRILL-7523 Update Calcite to 1.31.0