I tried this on latest master - looks like its stuck at planning stage (explain plan hangs).
Any slight modification to the create View2 query in the "trim" section makes the select * query succeed (for example changing '' to ' '). I'm not sure if this will help narrow down the issue though. -Abhishek On Fri, Nov 13, 2015 at 8:55 AM, Abdel Hakim Deneche <[email protected]> wrote: > 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 > > >
