Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
MIME-Version: 1.0
In-Reply-To: <1500284655431-14994.post@n6.nabble.com>
References: <1500019486311-14884.post@n6.nabble.com> <CANCAXEGC3FmiKritWmkksgYu0ks-bS9DtavprjNUj5c_P0CxwQ@mail.gmail.com>
 <1500026328849-14891.post@n6.nabble.com> <1500030616118-14903.post@n6.nabble.com>
 <CANCAXEGueBr-KRUhWQ-L5YyoEOXy+H94+_ue7pEs_ykp+aF=Rw@mail.gmail.com>
 <1500036756129-14906.post@n6.nabble.com> <CANCAXEFx3BKLNuEh09ZmME1dwCDzEKkeDw=8-iSpwZ0ji4BbUA@mail.gmail.com>
 <1500284655431-14994.post@n6.nabble.com>
From: Andrey Mashenkov <andrey.mashenkov@gmail.com>
Date: Mon, 17 Jul 2017 13:24:22 +0300
Message-ID: <CANCAXEF26AtT-wbDJfhgMmUcCppkFV28S6Bxu_QyvZZ3tjvrdQ@mail.gmail.com>
Subject: Re: sql query in case of cluster group
To: user@ignite.apache.org
Content-Type: multipart/alternative; boundary="001a114e59f46ff426055480cd9f"
archived-at: Mon, 17 Jul 2017 10:24:35 -0000

--001a114e59f46ff426055480cd9f
Content-Type: text/plain; charset="UTF-8"

1. LIMIT make no sense without ORDER for non-local queries and when
sqlQueryParallelizm > 1.
As in that case, data from different index segments will be merged out of
order and you can get different results with same query from run to run .

2. You use ClusterGroup to make your jobs to be run on certain nodes, but
it doesn't affect operations inside a job.
So, non-local sql query will be run on all data nodes.

On Mon, Jul 17, 2017 at 12:44 PM, neerajbhatt <neerajbhatt2000@gmail.com>
wrote:

> Hi Andrew
>
> It seems to be an order by issue. We have created a test project in github
> https://github.com/neerajbhatt/testIgnite
>
> If we use PutItems to put some records in a partitioned cache(TESTCACHE)
> args[0]=number of records, and then Get the items by
> GetItemsWithClusterGroup args[0] = query type (0 or 1), args[1]= number of
> queries and args [3] as last digit of ip.
>
> for first query ("SELECT T.id FROM " + "TESTCache.TestItem as T LIMIT 3")
> different ids are given for different cluster groups( each cluster group
> having one node)
>
> for second query ("SELECT T.id FROM " + "TESTCache.TestItem as T order by
> field1 desc LIMIT 3") we are getting same ids for each cluster group. It
> seems in case of order by instead of cluster group data is being fetched
> from whole cluster.
>
> Please suggest
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/sql-query-in-case-of-cluster-group-tp14884p14994.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>


-- 
Best regards,
Andrey V. Mashenkov

--001a114e59f46ff426055480cd9f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">1. LIMIT make no sense without ORDER for non-local queries=
 and when sqlQueryParallelizm &gt; 1.=C2=A0<div>As in that case, data from =
different index segments will be merged out of order and you can get differ=
ent results with same query from run to run=C2=A0.</div><div><br><div>2. Yo=
u use ClusterGroup to make your jobs to be run on certain nodes, but it doe=
sn&#39;t affect operations inside a job.</div><div>So, non-local sql query =
will be run on all data nodes.</div></div></div><div class=3D"gmail_extra">=
<br><div class=3D"gmail_quote">On Mon, Jul 17, 2017 at 12:44 PM, neerajbhat=
t <span dir=3D"ltr">&lt;<a href=3D"mailto:neerajbhatt2000@gmail.com" target=
=3D"_blank">neerajbhatt2000@gmail.com</a>&gt;</span> wrote:<br><blockquote =
class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid=
;padding-left:1ex">Hi Andrew<br>
<br>
It seems to be an order by issue. We have created a test project in github<=
br>
<a href=3D"https://github.com/neerajbhatt/testIgnite" rel=3D"noreferrer" ta=
rget=3D"_blank">https://github.com/<wbr>neerajbhatt/testIgnite</a><br>
<br>
If we use PutItems to put some records in a partitioned cache(TESTCACHE)<br=
>
args[0]=3Dnumber of records, and then Get the items by<br>
GetItemsWithClusterGroup args[0] =3D query type (0 or 1), args[1]=3D number=
 of<br>
queries and args [3] as last digit of ip.<br>
<br>
for first query (&quot;SELECT T.id FROM &quot; + &quot;TESTCache.TestItem a=
s T LIMIT 3&quot;)<br>
different ids are given for different cluster groups( each cluster group<br=
>
having one node)<br>
<br>
for second query (&quot;SELECT T.id FROM &quot; + &quot;TESTCache.TestItem =
as T order by<br>
field1 desc LIMIT 3&quot;) we are getting same ids for each cluster group. =
It<br>
seems in case of order by instead of cluster group data is being fetched<br=
>
from whole cluster.<br>
<br>
Please suggest<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href=3D"http://apache-ignite-users.70518.x=
6.nabble.com/sql-query-in-case-of-cluster-group-tp14884p14994.html" rel=3D"=
noreferrer" target=3D"_blank">http://apache-ignite-users.<wbr>70518.x6.nabb=
le.com/sql-query-<wbr>in-case-of-cluster-group-<wbr>tp14884p14994.html</a><=
br>
Sent from the Apache Ignite Users mailing list archive at Nabble.com.<br>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><d=
iv>Best regards,<br>Andrey V. Mashenkov<br></div></div></div>
</div>

--001a114e59f46ff426055480cd9f--