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: <1465274252950-5473.post@n6.nabble.com>
References: <1465208397540-5448.post@n6.nabble.com> <CAMegbcK7vhaUwjKqg7956j9Upuwx4g24=_ELtDysvFSfGqbPtg@mail.gmail.com>
 <1465274252950-5473.post@n6.nabble.com>
From: Alexei Scherbakov <alexey.scherbakoff@gmail.com>
Date: Tue, 7 Jun 2016 12:59:40 +0300
Message-ID: <CAMegbc+OrLd=wCpvTGbbrpho-eeBZu76aERsYLBbC8XenYwBZA@mail.gmail.com>
Subject: Re: Self Join Query As An Alternative To IN clause
To: user <user@ignite.apache.org>
Content-Type: multipart/alternative; boundary=001a11c1183660bf0f0534ad3fad
archived-at: Tue, 07 Jun 2016 09:59:46 -0000

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

Hi

Because the H2 engine works this way.

Look carefully into the documentation [1]

[1]
https://apacheignite.readme.io/docs/sql-queries#performance-and-usability-considerations

2016-06-07 7:37 GMT+03:00 pragmaticbigdata <amits.84@gmail.com>:

> Great. The query worked now and it is 50% faster than the in clause query.
> Could you detail on the internals of why passing the object array directly
> didn't work and how did an [] inside an [] worked out?
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Self-Join-Query-As-An-Alternative-To-IN-clause-tp5448p5473.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>


-- 

Best regards,
Alexei Scherbakov

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

<div dir=3D"ltr">Hi<div><br></div><div>Because the H2 engine works this way=
.</div><div><br></div><div>Look carefully into the documentation [1]</div><=
div><br></div><div>[1] <a href=3D"https://apacheignite.readme.io/docs/sql-q=
ueries#performance-and-usability-considerations">https://apacheignite.readm=
e.io/docs/sql-queries#performance-and-usability-considerations</a><br></div=
></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">2016-06-07=
 7:37 GMT+03:00 pragmaticbigdata <span dir=3D"ltr">&lt;<a href=3D"mailto:am=
its.84@gmail.com" target=3D"_blank">amits.84@gmail.com</a>&gt;</span>:<br><=
blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex">Great. The query worked now and it is 50% fas=
ter than the in clause query.<br>
Could you detail on the internals of why passing the object array directly<=
br>
didn&#39;t work and how did an [] inside an [] worked out?<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href=3D"http://apache-ignite-users.70518.x=
6.nabble.com/Self-Join-Query-As-An-Alternative-To-IN-clause-tp5448p5473.htm=
l" rel=3D"noreferrer" target=3D"_blank">http://apache-ignite-users.70518.x6=
.nabble.com/Self-Join-Query-As-An-Alternative-To-IN-clause-tp5448p5473.html=
</a><br>
<div class=3D"HOEnZb"><div class=3D"h5">Sent from the Apache Ignite Users m=
ailing list archive at Nabble.com.<br>
</div></div></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"><div><div dir=3D"ltr"><div dir=3D"ltr"></div><div><div dir=3D"ltr"=
><br>Best regards,<br></div><div>Alexei Scherbakov<br></div></div></div></d=
iv></div></div>
</div>

--001a11c1183660bf0f0534ad3fad--