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]

Reply via email to