You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Stamatis Zampetakis <za...@gmail.com> on 2019/02/05 13:59:14 UTC
[Discuss] (CALCITE-2696) Make it easier to configure SqlToRelConverter.Config.getInSubQueryThreshold()
The author of the Jira [1] wants an easy way to configure the sub query
threshold potentially using some property.
He has pinged us quite a few times so it would be good to provide a
direction on how to do it or give a definitive answer that we are not going
to do it.
I gave my opinion in the Jira but it would be great if somebody else can
also have a look.
Best,
Stamatis
[1] https://issues.apache.org/jira/browse/CALCITE-2696
Re: [Discuss] (CALCITE-2696) Make it easier to configure SqlToRelConverter.Config.getInSubQueryThreshold()
Posted by Stamatis Zampetakis <za...@gmail.com>.
If I am not mistaken currently there is no way to use a custom Planner by
passing information through the JDBC connection string or through the
properties. Am I missing something?
Στις Τετ, 6 Φεβ 2019 στις 8:45 μ.μ., ο/η Julian Hyde <jh...@apache.org>
έγραψε:
> Is there a way to inject a custom org.apache.calcite.prepare.Planner?
> PlannerImpl contains a FrameworkConfig, and in that they can override
> SqlToRelConverter.Config.
>
> Of course they want really, really easy. But sub-query threshold is a
> planning parameter and I don’t want this stuff to be really easy. Just as
> Ford does not want to make it easy for you to alter the gas:air ratio going
> into your engine.
>
> The sketch in paragraph 1 may sound complicated but it’s just a few lines
> of code.
>
> Julian
>
>
> > On Feb 5, 2019, at 5:59 AM, Stamatis Zampetakis <za...@gmail.com>
> wrote:
> >
> > The author of the Jira [1] wants an easy way to configure the sub query
> > threshold potentially using some property.
> >
> > He has pinged us quite a few times so it would be good to provide a
> > direction on how to do it or give a definitive answer that we are not
> going
> > to do it.
> >
> > I gave my opinion in the Jira but it would be great if somebody else can
> > also have a look.
> >
> > Best,
> > Stamatis
> >
> > [1] https://issues.apache.org/jira/browse/CALCITE-2696
>
>
Re: [Discuss] (CALCITE-2696) Make it easier to configure
SqlToRelConverter.Config.getInSubQueryThreshold()
Posted by Julian Hyde <jh...@apache.org>.
Is there a way to inject a custom org.apache.calcite.prepare.Planner? PlannerImpl contains a FrameworkConfig, and in that they can override SqlToRelConverter.Config.
Of course they want really, really easy. But sub-query threshold is a planning parameter and I don’t want this stuff to be really easy. Just as Ford does not want to make it easy for you to alter the gas:air ratio going into your engine.
The sketch in paragraph 1 may sound complicated but it’s just a few lines of code.
Julian
> On Feb 5, 2019, at 5:59 AM, Stamatis Zampetakis <za...@gmail.com> wrote:
>
> The author of the Jira [1] wants an easy way to configure the sub query
> threshold potentially using some property.
>
> He has pinged us quite a few times so it would be good to provide a
> direction on how to do it or give a definitive answer that we are not going
> to do it.
>
> I gave my opinion in the Jira but it would be great if somebody else can
> also have a look.
>
> Best,
> Stamatis
>
> [1] https://issues.apache.org/jira/browse/CALCITE-2696