ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexei Scherbakov <alexey.scherbak...@gmail.com>
Subject Re: Self Join Query As An Alternative To IN clause
Date Tue, 07 Jun 2016 09:59:40 GMT
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

Mime
View raw message