Boris, this is definitely a bug, the query seems to be blocked in planning. Please open a JIRA.
Thanks On Fri, Nov 13, 2015 at 9:03 AM, Abhishek Girish <[email protected]> wrote: > 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 > > > > > > -- 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>
