If you enable these tests, most of them can run successfully, though maybe not
so efficient. All you need to do is just enabling these tests.
- Haisheng
------------------------------------------------------------------
发件人：Stamatis Zampetakis<zabe...@gmail.com>
日 期：2020年03月29日 22:58:22
收件人：<dev@calcite.apache.org>
主 题：Re: Re: Doubts about TPCH queries with volcano planner
Hey Aron,
Yes, we should fix these issues. Every @Disabled test is a future TODO
otherwise it wouldn't be there :)
Contributions are welcomed!
Stamatis
On Fri, Mar 27, 2020 at 6:36 AM JiaTao Tao <taojia...@gmail.com> wrote:
> Hi Haishen, Chunwei
> Sorry for the pic, it just the content of TpchTest, here I quote directly:
>
> >
> > TPCH02 @Disabled("Infinite planning")
> > TPCH04 @Disabled("NoSuchMethodException: SqlFunctions.lt(Date, Date)")
> > TPCH05 @Disabled("OutOfMemoryError")
> > TPCH09 @Disabled("no method found")
> > TPCH11 @Disabled("CannotPlanException")
> > TPCH12 @Disabled("NoSuchMethodException: SqlFunctions.lt(Date, Date)")
> > TPCH13 @Disabled("CannotPlanException")
> > TPCH15 @Disabled("AssertionError")
> > TPCH19 May be timeout
> > TPCH22 @Disabled("IllegalArgumentException during decorrelation")
>
>
> And my statement may not be clear, what I wonder is that with calcite's
> default rule set (RelOptUtil#registerDefaultRules), why there are so many
> TPCH queries fails? IMO, we should fix these issues, cuz the default rule
> set means the general optimization.
>
> Regards!
>
> Aron Tao
>
>
> Haisheng Yuan <h.y...@alibaba-inc.com> 于2020年3月27日周五 上午11:41写道：
>
> > No one can see the picture. He has to paste the link to the picture.
> >
> > Calcite's volcano planner is production ready, without any question. You
> > need to customize the adaptor and rules to fit into your system.
> >
> > - Haisheng
> >
> > ------------------------------------------------------------------
> > 发件人：Chunwei Lei<chunwei.l...@gmail.com>
> > 日 期：2020年03月27日 11:28:31
> > 收件人：<dev@calcite.apache.org>
> > 主 题：Re: Doubts about TPCH queries with volcano planner
> >
> > Calcite is a framework for paring and optimizing the query. The volcano
> > planner is always available if you leverage it correctly.
> >
> > Besides, am I the only person who cannot see the picture?
> >
> >
> > Best,
> > Chunwei
> >
> >
> > On Thu, Mar 26, 2020 at 1:30 PM JiaTao Tao <t...@apache.org> wrote:
> >
> > > Hi all
> > > Currently, I'm studying the volcano planner and found that many TPCH
> > > queries failed to optimize.
> > >
> > > See in org.apache.calcite.adapter.tpch.TpchTest:
> > >
> > > And here comes the question: Is volcano planner production ready? If
> so,
> > > why there are so many TPCH queries fails? Do we have plans to support
> > > these queries?
> > >
> > > [image: image.png]
> > >
> > >
> > > Regards!
> > >
> > > Aron Tao
> > >
> >
> >
>
