[ https://issues.apache.org/jira/browse/DRILL-4086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17568445#comment-17568445 ]
James Turton commented on DRILL-4086: ------------------------------------- Reconfirmed using Drill master including after replacing the column delimiter with ',' (';' was not the delimiter char under my config). [~volodymyr] may we test after the Calcite upgrade please? > Query hangs in planing > ---------------------- > > Key: DRILL-4086 > URL: https://issues.apache.org/jira/browse/DRILL-4086 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 1.2.0 > Reporter: boris chmiel > Priority: Major > > The query is stuck seems blocked on planning (pending) > View : > {noformat} > 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]) <> '' > ); > {noformat} > {noformat} > 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) <> '' > ); > {noformat} > Query : > {noformat} > select * FROM dfs.tmp.View2 > {noformat} > => Infinite Pending > data set : > {panel:title=B1} > A; > B;F > C;A > D;E > E; > F;C > {panel} > {panel:title=BK} > A;1 > B;2 > F;4 > {panel} -- This message was sent by Atlassian Jira (v8.20.10#820010)