ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitriy Setrakyan <dsetrak...@apache.org>
Subject Re: CREATE TABLE SQL command syntax
Date Wed, 12 Apr 2017 02:11:53 GMT

Can you please provide an example of what the CREATE TABLE command would
look like if we use WITH syntax from H2 vs. what you are proposing?


On Tue, Apr 11, 2017 at 6:35 PM, Alexander Paschenko <
alexander.a.paschenko@gmail.com> wrote:

> Hello Igniters,
> Yup, it's THAT time once again as we haven't ultimately settled on
> anything with the subj. as of yet, but I believe that now with DDL on
> its way this talk can't be avoided anymore (sorry guys).
> The last time we talked about Ignite specific stuff we need to have in
> CREATE TABLE (key fields list, affinity key, am I missing anything?),
> the simplest approach suggested by Sergi was that we simply use WITH
> part of H2's CREATE TABLE to pass stuff we need.
> This could work, but needless to say that such commands would look plain
> ugly.
> I think we should go with custom syntax after all, BUT not in a way
> suggested before by Sergi (propose Apache Ignite mode to H2).
> Instead, I suggest that we propose to H2 patch that would allow
> plugging in *custom SQL parser* directly based on theirs (quite
> elegant one) – I've had a look at their code, and this should not be
> hard.
> Work on such a patch making syntax parsing overridable would take a
> couple days which is not much time AND would give us the opportunity
> to introduce to Ignite virtually any syntax we wish - both now and in
> the future. Without worrying about compatibility with H2 ever again,
> that is.
> Thoughts? After we agree on this principally and after H2 patch for
> custom parsing is ready, we can roll our sleeves and focus on syntax
> itself.
> - Alex

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