You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Boris Chmiel <bo...@yahoo.com.INVALID> on 2015/11/13 17:03:56 UTC
Infinite pending Bug ?
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
Re: Infinite pending Bug ?
Posted by Boris Chmiel <bo...@yahoo.com.INVALID>.
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 <hy...@maprtech.com> a écrit :
Do you know if it is stuck at planning?
On Fri, Nov 13, 2015 at 8:03 AM, Boris Chmiel <
boris.chmiel@yahoo.com.invalid> 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
>
Re: Infinite pending Bug ?
Posted by Abdel Hakim Deneche <ad...@maprtech.com>.
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 <ab...@gmail.com>
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 <
> adeneche@maprtech.com>
> wrote:
>
> > Hello Boris,
> >
> > What version of Drill are you using ?
> >
> > Thanks
> >
> > On Fri, Nov 13, 2015 at 8:33 AM, Hsuan Yi Chu <hy...@maprtech.com>
> wrote:
> >
> > > Do you know if it is stuck at planning?
> > >
> > > On Fri, Nov 13, 2015 at 8:03 AM, Boris Chmiel <
> > > boris.chmiel@yahoo.com.invalid> 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>
Re: Infinite pending Bug ?
Posted by Abhishek Girish <ab...@gmail.com>.
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 <ad...@maprtech.com>
wrote:
> Hello Boris,
>
> What version of Drill are you using ?
>
> Thanks
>
> On Fri, Nov 13, 2015 at 8:33 AM, Hsuan Yi Chu <hy...@maprtech.com> wrote:
>
> > Do you know if it is stuck at planning?
> >
> > On Fri, Nov 13, 2015 at 8:03 AM, Boris Chmiel <
> > boris.chmiel@yahoo.com.invalid> 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
> >
>
Re: Infinite pending Bug ?
Posted by Abdel Hakim Deneche <ad...@maprtech.com>.
Hello Boris,
What version of Drill are you using ?
Thanks
On Fri, Nov 13, 2015 at 8:33 AM, Hsuan Yi Chu <hy...@maprtech.com> wrote:
> Do you know if it is stuck at planning?
>
> On Fri, Nov 13, 2015 at 8:03 AM, Boris Chmiel <
> boris.chmiel@yahoo.com.invalid> 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>
Re: Infinite pending Bug ?
Posted by Hsuan Yi Chu <hy...@maprtech.com>.
Do you know if it is stuck at planning?
On Fri, Nov 13, 2015 at 8:03 AM, Boris Chmiel <
boris.chmiel@yahoo.com.invalid> 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
>