I think so,There is no Physical plan created, no JSON profil.When I turn my View to Table it works. I'm using 1.2 embedded
thanks Le Vendredi 13 novembre 2015 17h33, Hsuan Yi Chu <[email protected]> a écrit : Do you know if it is stuck at planning? On Fri, Nov 13, 2015 at 8:03 AM, Boris Chmiel < [email protected]> wrote: > 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 >
