Re: Using SORT BY and ORDER BY

Hello! By putting your affinity column in the public key of all tables and issuing WITH "affinity_key=" clause when creating table. Please also see https://apacheignite.readme.io/docs/affinity-collocation Regards, -- Ilya Kasnacheev пт, 10 июл. 2020 г. в 18:32, Surkov.Aleksandr : > There is

Re: Using SORT BY and ORDER BY

There is the question. It turns out that I need to collocate the table, because the field COL will have different values? But how can i do this? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Using SORT BY and ORDER BY

Thank you! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Using SORT BY and ORDER BY

The org.apache.ignite.internal.processors.cache.query.CacheQuery interface has a comment: * {@code Group by} and {@code sort by} statements are applied separately * on each node, so result set will likely be incorrectly grouped or sorted * after results from multiple

Re: Using SORT BY and ORDER BY

Hello! 1. I guess it is a honest mistake. 2. The idea here is that you can't expect that GROUP BY COL will return anything relevant, if the table is not collocated by COL. Regards, -- Ilya Kasnacheev пт, 10 июл. 2020 г. в 17:34, Surkov.Aleksandr : > The