git.net

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

Re: Hints support


I did not start prototyping yet but I will share my thoughts on the API the
Jira (CALCITE-482) once ready.
In Apache Drill we are considering to pass schema using hints, something
similar to extend clause but with more options.
In future we might consider adding support for index and join hints.

Kind regards,
Arina

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

> Can you explain what you mean by “store”?  Describe the API changes you’d
> like, or unit tests.
>
> Julian
>
> > On Oct 10, 2018, at 08:16, Arina Yelchiyeva <arina.yelchiyeva@xxxxxxxxx>
> wrote:
> >
> > 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
> >>
>