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 <sergi.vlady...@gmail.com> 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 <voze...@gridgain.com>: > > > This was exactly what I meant. We need native H2 support here. > > > > On Fri, Jun 2, 2017 at 5:46 PM, Sergi Vladykin <sergi.vlady...@gmail.com > > > > 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 <akuznet...@apache.org>: > > > > > > > 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 < > voze...@gridgain.com> > > > > 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 < > > > akuznet...@apache.org> > > > > > wrote: > > > > > > > > > > > I like this, but could you show some examples? > > > > > > > > > > > > On Fri, Jun 2, 2017 at 9:08 PM, Vladimir Ozerov < > > > voze...@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 > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Alexey Kuznetsov > > > > > > > > > >
