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 <[email protected]> 于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<[email protected]>
> 日 期：2020年03月27日 11:28:31
> 收件人：<[email protected]>
> 主 题：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 <[email protected]> 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
> >
>
>
