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/08/18 19:16:36 UTC
UNION infinite Pending
I found that creating a View with more than 7 UNION clause on the same table (around 40 Operators), leads the query to remain infinitely in PENDING status on my configuration. The Physical Plan is not created. Maybe It is about parameter tuning. Any idea ?
Re: UNION infinite Pending
Posted by Boris Chmiel <bo...@yahoo.com.INVALID>.
JIRA opened : https://issues.apache.org/jira/browse/DRILL-3671
Le Mardi 18 août 2015 19h28, Jinfeng Ni <ji...@gmail.com> a écrit :
If the query remains infinitely in PENDING status, and you did not get a
Physical Plan, that might indicate a bug in the sql planner & optimizer.
You may open a JIRA, and provide your view DDL so that we can see if we
could re-produce it.
On Tue, Aug 18, 2015 at 10:16 AM, Boris Chmiel <
boris.chmiel@yahoo.com.invalid> wrote:
>
> I found that creating a View with more than 7 UNION clause on the same
> table (around 40 Operators), leads the query to remain infinitely in
> PENDING status on my configuration. The Physical Plan is not created. Maybe
> It is about parameter tuning. Any idea ?
Re: UNION infinite Pending
Posted by Jinfeng Ni <ji...@gmail.com>.
If the query remains infinitely in PENDING status, and you did not get a
Physical Plan, that might indicate a bug in the sql planner & optimizer.
You may open a JIRA, and provide your view DDL so that we can see if we
could re-produce it.
On Tue, Aug 18, 2015 at 10:16 AM, Boris Chmiel <
boris.chmiel@yahoo.com.invalid> wrote:
>
> I found that creating a View with more than 7 UNION clause on the same
> table (around 40 Operators), leads the query to remain infinitely in
> PENDING status on my configuration. The Physical Plan is not created. Maybe
> It is about parameter tuning. Any idea ?