Hi Andrew It seems to be an order by issue. We have created a test project in github https://github.com/neerajbhatt/testIgnite
If we use PutItems to put some records in a partitioned cache(TESTCACHE) args[0]=number of records, and then Get the items by GetItemsWithClusterGroup args[0] = query type (0 or 1), args[1]= number of queries and args [3] as last digit of ip. for first query ("SELECT T.id FROM " + "TESTCache.TestItem as T LIMIT 3") different ids are given for different cluster groups( each cluster group having one node) for second query ("SELECT T.id FROM " + "TESTCache.TestItem as T order by field1 desc LIMIT 3") we are getting same ids for each cluster group. It seems in case of order by instead of cluster group data is being fetched from whole cluster. Please suggest -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/sql-query-in-case-of-cluster-group-tp14884p14994.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.