Hi,
One of my sql query (pasted below) execution result depends on the active
running ignite node count. I have my code which is based on the
ignite-examples posted here
<https://gist.github.com/anonymous/8e2af218598e46577b2a> for review, along
with data sample.
Ideally I expect the result of the query to be: *[pA, 1000.0]*
Please help review the code if I am doing anything wrong.
Regards,
Moiz
Query :
"select customer, sum(bal) from (" +
"select customer,bank, min(balance) bal " +
"from Customer group by customer,bank " +
") v0 " +
"group by customer "
Output from various run:
*Run 1*
-----------
[23:57:50] Topology snapshot [ver=2, *servers=3,* clients=1, CPUs=4,
heap=10.0GB]
>>> Cache data streamer example started.
>>> * [pA, 3000.0]*
[23:57:52] Ignite node stopped OK [uptime=00:00:01:230]
-----------
Run 2
------------
[00:16:01] Ignite node started OK (id=47f268d4)
[00:16:01] Topology snapshot [ver=2, *servers=2*, clients=1, CPUs=4, heap=7.7GB]
>>> Cache data streamer example started.
>>> *[pA, 2000.0]*
[00:16:02] Ignite node stopped OK [uptime=00:00:01:28]
------------
*Run 3*
------------
[00:16:47] Ignite node started OK (id=846899fb)
[00:16:47] Topology snapshot [ver=2, *servers=1*, clients=1, CPUs=4, heap=5.2GB]
>>> Cache data streamer example started.
>>> *[pA, 1000.0]*
[00:16:47] Ignite node stopped OK [uptime=00:00:00:761]