git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Hints support


Thanks, Julian. I'll take a look at the Jiras first.
Though for my use case I just need Calcite to store the hints, how they
would be applied would be decided outside of Calcite.

Kind regards,
Arina

On Wed, Oct 10, 2018 at 6:06 PM Julian Hyde <jhyde.apache@xxxxxxxxx> wrote:

> We’ve discussed hints before. There may even be a JIRA case. I’d like to
> see a concrete proposal, not just for syntax, but how the hints would make
> their way through relational algebra.
>
> Julian
>
> > On Oct 10, 2018, at 07:57, Arina Yelchiyeva <arina.yelchiyeva@xxxxxxxxx>
> wrote:
> >
> > Hi all,
> >
> > currently Calcite does not support hints. Since usually hints are
> expressed
> > as multi-line comment after SELECT keyword followed by the plus sign [1],
> > Calcite ignores them as all others comments.It can be useful if Calcite
> > will provide functionality to store hints and allow source system to use
> > them during planning / execution time.
> >
> > Any thoughts?
> >
> > [1] https://docs.oracle.com/cd/B12037_01/server.101/b10752/hintsref.htm
> >
> > Kind regards,
> > Arina
>