Mailing-List: contact dev-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ignite.apache.org
MIME-Version: 1.0
In-Reply-To: <CA+0=VoUkRq50NtwxLoFEjCQV1kZLHakzy8hudpRkYhL_jG3WAQ@mail.gmail.com>
References: <CA+0=VoUVsefO1_54mXgcH8zN6-=QOXCU+Xjbq8h92eMzt_VGBg@mail.gmail.com>
 <0B7F19C7-231D-4C3F-83C6-D232059B8CF9@apache.org> <CA+0=VoVANorPWDxvY7Mi7Lw7LZuMk+RPJRWe2ycTFGGJpTnHdg@mail.gmail.com>
 <759FAA7E-FB31-4449-BE35-C7C597E3731C@apache.org> <CABuYRcouWPy7ricODdXoZ66YRC-v4nuFNX=U6nLm5sDm53d5qA@mail.gmail.com>
 <CA+0=VoUkRq50NtwxLoFEjCQV1kZLHakzy8hudpRkYhL_jG3WAQ@mail.gmail.com>
From: Alexander Paschenko <alexander.a.paschenko@gmail.com>
Date: Mon, 19 Dec 2016 14:32:13 +0300
Message-ID: <CAJhSPbpRwr85ez-dQgfOBPF08gSv=tB00ibyWS7FppzbvZuXRg@mail.gmail.com>
Subject: Re: Communication from JDBC/ODBC drivers
To: dev@ignite.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
archived-at: Mon, 19 Dec 2016 11:32:18 -0000

Dima, Val,

Introduction of updates has not changed public API at all (only
configuration, in some cases), so they work in this respect exactly
like SELECTs - by default they run on client node started by the
driver itself, but can be sent via the same callables mechanism to any
remote node by its id.

So Dima, you're right, currently it's possible to send query to any
given node. And, at the same time, currently by default everything
works exactly like you want it to - that is, any MERGE, batched or
not, boils down to putAll, and by default this call happens locally.

- Alex

2016-12-17 18:47 GMT+03:00 Dmitriy Setrakyan <dsetrakyan@apache.org>:
> On Fri, Dec 16, 2016 at 9:53 PM, Valentin Kulichenko <
> valentin.kulichenko@gmail.com> wrote:
>
>> I'm not sure about updates, but can tell about how selects are implement=
ed
>> there. Basically, there is an option to execute the query on a particula=
r
>> node specified by ignite.jdbc.nodeId property. Not sure why we need this
>> though, probably it's just leftover from the legacy version of the drive=
r
>> based on thin client.
>>
>> If the property is set, the callable is sent to a remote node. But if it=
 is
>> not, the same callable is created, but it is invoked directly on the
>> embedded client which is the behavior that you expect. And it's the defa=
ult
>> one.
>>
>>
> Ouch. If this is the reason, I would drop the nodeId property. I don't
> think it makes sense and it significantly slows down the implementation.
>
>
>> -Val
>>
>> On Fri, Dec 16, 2016 at 7:51 PM, Denis Magda <dmagda@apache.org> wrote:
>>
>> > Frankly speaking, even single (non batched) updates or queries are sen=
t
>> as
>> > callables. This is what I see in the code.
>> > No idea what was the reason behind this design.
>> >
>> > Andrey G., Alex P. could you shed a light on this?
>> >
>> > =E2=80=94
>> > Denis
>> >
>> > > On Dec 16, 2016, at 3:08 PM, Dmitriy Setrakyan <dsetrakyan@apache.or=
g>
>> > wrote:
>> > >
>> > > To my understanding, we are implementing JDBC batches by sending a
>> > callable
>> > > to another node. If we already have a client node on the JDBC driver
>> > side,
>> > > why not just issue a putAll(...) call from the client?
>> > >
>> > > D.
>> > >
>> > > On Fri, Dec 16, 2016 at 3:02 PM, Denis Magda <dmagda@apache.org>
>> wrote:
>> > >
>> > >> Dmitriy,
>> > >>
>> > >> JDBC drivers spawns an Ignite client node and uses it for cluster
>> > >> connectivity and queries execution. Queries issued over the JDBC ar=
e
>> > turned
>> > >> into SqlFieldsQueries and sent to the cluster in this form.
>> > >>
>> > >> ODBC driver works in a bit different way. It connects to the cluste=
r
>> via
>> > >> ODBC processor that needs to be running on one of the nodes:
>> > >> https://apacheignite.readme.io/docs/odbc-driver#cluster-configurati=
on
>> <
>> > >> https://apacheignite.readme.io/docs/odbc-driver#cluster-configurati=
on
>> >
>> > >>
>> > >> =E2=80=94
>> > >> Denis
>> > >>
>> > >>> On Dec 16, 2016, at 2:41 PM, Dmitriy Setrakyan <
>> dsetrakyan@apache.org>
>> > >> wrote:
>> > >>>
>> > >>> Igniters,
>> > >>>
>> > >>> Can someone explain to me how Ignite executes SQL from JDBC and OD=
BC
>> > >>> drivers? Do we start an Ignite client node on the driver side? Or =
do
>> we
>> > >> use
>> > >>> some other protocol to send commands to one of the Ignite nodes?
>> > >>>
>> > >>> Thanks,
>> > >>> D.
>> > >>
>> > >>
>> >
>> >
>>