ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergi Vladykin <sergi.vlady...@gmail.com>
Subject Re: Expose SqlQueryFields flags as SQL hints
Date Fri, 02 Jun 2017 14:28:08 GMT
I'd prefer to avoid inventing any brand new SQL syntax.

Sergi

2017-06-02 17:23 GMT+03:00 Vladimir Ozerov <vozerov@gridgain.com>:

> Well, looks like H2 doesn't support hints at the moment, and there is no
> way to add some custom params to SELECT (it is possible for CREATE TABLE
> and CREATE SCHEMA) only. Anyway, this could be nice usability improvement
> for us.
>
> On Fri, Jun 2, 2017 at 5:13 PM, Alexey Kuznetsov <akuznetsov@apache.org>
> wrote:
>
> > I like this, but could you show some examples?
> >
> > On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov <vozerov@gridgain.com>
> > wrote:
> >
> > > Folks,
> > >
> > > We have quite a few flags on SqlFields and SqlQueryFields classes which
> > are
> > > used for fine tuning. Probably even more flags will appear soon. AFAIK
> > > special compatibility mode for Apache Ignite was added to H2 parser
> > > recently. I think we can expose all these flags as SQL hints in the
> query
> > > itself, rather then setting them programmatically (or through JDBC/ODBC
> > > connection strings).
> > >
> > > Thoughts?
> > >
> > > Vladimir.
> > >
> >
> >
> >
> > --
> > Alexey Kuznetsov
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message