Expose SqlQueryFields flags as SQL hints

[Vladimir Ozerov]

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]

I like this, but could you show some examples?

On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov <[hidden email]>
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

[Vladimir Ozerov]

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 <[hidden email]>
wrote:

> I like this, but could you show some examples?
>
> On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov <[hidden email]>
> 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
>

[Sergi]

I'd prefer to avoid inventing any brand new SQL syntax.

Sergi

2017-06-02 17:23 GMT+03:00 Vladimir Ozerov <[hidden email]>:

> 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 <[hidden email]>
> wrote:
>
> > I like this, but could you show some examples?
> >
> > On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov <[hidden email]>
> > 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
> >
>

[Alexey Kuznetsov]

Hints discussion on H2 user group:
https://groups.google.com/d/topic/h2-database/dHwbBitzXlY/discussion

On Fri, Jun 2, 2017 at 9:23 PM, Vladimir Ozerov <[hidden email]>
wrote:

> 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 <[hidden email]>
> wrote:
>
> > I like this, but could you show some examples?
> >
> > On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov <[hidden email]>
> > 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
> >
>

--
Alexey Kuznetsov

[Sergi]

IMO the correct way is to implement generic hints for H2 first and plug
Ignite hints there.

Sergi

2017-06-02 17:31 GMT+03:00 Alexey Kuznetsov <[hidden email]>:

> Hints discussion on H2 user group:
> https://groups.google.com/d/topic/h2-database/dHwbBitzXlY/discussion
>
> On Fri, Jun 2, 2017 at 9:23 PM, Vladimir Ozerov <[hidden email]>
> wrote:
>
> > 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 <[hidden email]>
> > wrote:
> >
> > > I like this, but could you show some examples?
> > >
> > > On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov <[hidden email]>
> > > 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
> > >
> >
>
>
>
> --
> Alexey Kuznetsov
>

[Vladimir Ozerov]

This was exactly what I meant. We need native H2 support here.

On Fri, Jun 2, 2017 at 5:46 PM, Sergi Vladykin <[hidden email]>
wrote:

> IMO the correct way is to implement generic hints for H2 first and plug
> Ignite hints there.
>
> Sergi
>
> 2017-06-02 17:31 GMT+03:00 Alexey Kuznetsov <[hidden email]>:
>
> > Hints discussion on H2 user group:
> > https://groups.google.com/d/topic/h2-database/dHwbBitzXlY/discussion
> >
> > On Fri, Jun 2, 2017 at 9:23 PM, Vladimir Ozerov <[hidden email]>
> > wrote:
> >
> > > 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 <
> [hidden email]>
> > > wrote:
> > >
> > > > I like this, but could you show some examples?
> > > >
> > > > On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov <
> [hidden email]>
> > > > 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
> > > >
> > >
> >
> >
> >
> > --
> > Alexey Kuznetsov
> >
>

[Sergi]

To be clear I mean not to add some creative stuff under Ignite mode, but
instead add generic hints in H2 (without Ignite) first, then plug Ignite
stuff there so that it will work and look consistently with H2 hints.

I'm just trying to avoid situation when we add some our hints under Ignite
mode, after that H2 community will add their own hints in another format,
this will look freaky.

Sergi

2017-06-02 17:51 GMT+03:00 Vladimir Ozerov <[hidden email]>:

> This was exactly what I meant. We need native H2 support here.
>
> On Fri, Jun 2, 2017 at 5:46 PM, Sergi Vladykin <[hidden email]>
> wrote:
>
> > IMO the correct way is to implement generic hints for H2 first and plug
> > Ignite hints there.
> >
> > Sergi
> >
> > 2017-06-02 17:31 GMT+03:00 Alexey Kuznetsov <[hidden email]>:
> >
> > > Hints discussion on H2 user group:
> > > https://groups.google.com/d/topic/h2-database/dHwbBitzXlY/discussion
> > >
> > > On Fri, Jun 2, 2017 at 9:23 PM, Vladimir Ozerov <[hidden email]>
> > > wrote:
> > >
> > > > 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 <
> > [hidden email]>
> > > > wrote:
> > > >
> > > > > I like this, but could you show some examples?
> > > > >
> > > > > On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov <
> > [hidden email]>
> > > > > 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
> > > > >
> > > >
> > >
> > >
> > >
> > > --
> > > Alexey Kuznetsov
> > >
> >
>

[dsetrakyan]

Vova, what custom params are you suggestion? Can you be more specific? How
should they look in SQL?

On Fri, Jun 2, 2017 at 8:06 AM, Sergi Vladykin <[hidden email]>
wrote:

> To be clear I mean not to add some creative stuff under Ignite mode, but
> instead add generic hints in H2 (without Ignite) first, then plug Ignite
> stuff there so that it will work and look consistently with H2 hints.
>
> I'm just trying to avoid situation when we add some our hints under Ignite
> mode, after that H2 community will add their own hints in another format,
> this will look freaky.
>
> Sergi
>
> 2017-06-02 17:51 GMT+03:00 Vladimir Ozerov <[hidden email]>:
>
> > This was exactly what I meant. We need native H2 support here.
> >
> > On Fri, Jun 2, 2017 at 5:46 PM, Sergi Vladykin <[hidden email]
> >
> > wrote:
> >
> > > IMO the correct way is to implement generic hints for H2 first and plug
> > > Ignite hints there.
> > >
> > > Sergi
> > >
> > > 2017-06-02 17:31 GMT+03:00 Alexey Kuznetsov <[hidden email]>:
> > >
> > > > Hints discussion on H2 user group:
> > > > https://groups.google.com/d/topic/h2-database/dHwbBitzXlY/discussion
> > > >
> > > > On Fri, Jun 2, 2017 at 9:23 PM, Vladimir Ozerov <
> [hidden email]>
> > > > wrote:
> > > >
> > > > > 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 <
> > > [hidden email]>
> > > > > wrote:
> > > > >
> > > > > > I like this, but could you show some examples?
> > > > > >
> > > > > > On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov <
> > > [hidden email]>
> > > > > > 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
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Alexey Kuznetsov
> > > >
> > >
> >
>