Hello every one, I reach an infinite pending on a quite simple set of queries with very small files. Do you see a flaw in my queries or it is a bug ? View : create or replace view View1 AS (SELECT B1.columns[0] c0,B1.columns[1] c1FROM dfs.tmp.`TEST\B1.csv` B1LEFT OUTER JOIN dfs.tmp.`TEST\BK.csv` BKON 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.c1FROM View1LEFT OUTER JOIN dfs.tmp.`TEST\BK.csv` BKON 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;FC;AD;EE;F;C BK:A;1B;2F;4
