Re: "Select count(*) " returns incorrect records for distributed cache.

classic Classic list List threaded Threaded
1 message Options
Alexei Scherbakov Alexei Scherbakov
Reply | Threaded
Open this post in threaded view
|

Re: "Select count(*) " returns incorrect records for distributed cache.

Hi Rupinder

This is possible if you ran the query in the local mode (query.setLocal(true))
Check if it's not the case.



2016-06-09 11:24 GMT+03:00 Rupinder Virk <[hidden email]>:
Hi,

We are using Ignite-1.5.0-final version. On a 3 node cluster we created a
cache containing 10K records with *PARTITIONED * and *REPLICATED * mode.

Why the following query returns *1/3rd records* in PARTITIONED  mode
and *3x records* in REPLICATED  mode.

SqlFieldsQuery qry11 =  new SqlFieldsQuery("select count(*) from  \"" +
TABLE_CACHE_NAME + "\".Table t ");


Thanks,
Rupinder Virk



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Select-count-returns-incorrect-records-for-distributed-cache-tp5546.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.



--

Best regards,
Alexei Scherbakov