[jira] [Commented] (DRILL-4086) Query hangs in planing
[ https://issues.apache.org/jira/browse/DRILL-4086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17568651#comment-17568651 ] Vova Vysotskyi commented on DRILL-4086: --- It works with the updated Calcite version and returns the following results: {noformat} +++ | c0 | c1 | +++ | F | C | | D | E | +++ {noformat} > 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)
[jira] [Commented] (DRILL-4086) Query hangs in planing
[ https://issues.apache.org/jira/browse/DRILL-4086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)