boris chmiel created DRILL-4086: ----------------------------------- Summary: No planning created Key: DRILL-4086 URL: https://issues.apache.org/jira/browse/DRILL-4086 Project: Apache Drill Issue Type: Bug Components: Execution - Codegen Affects Versions: 1.2.0 Reporter: boris chmiel
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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)