You can try using UNION for this: (select * from cache1 where agid = 100 limit 2) union (select * from cache1 where agid = 101 limit 2)
https://gist.github.com/vkulichenko/8de603b28aa784ede84150614003e3a6 -Valid -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
