Hello Boris, What version of Drill are you using ?
Thanks On Fri, Nov 13, 2015 at 8:33 AM, Hsuan Yi Chu <[email protected]> wrote: > 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 > > > -- Abdelhakim Deneche Software Engineer <http://www.mapr.com/> Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
