[jira] [Created] (IGNITE-6375) CREATE TABLE affinityKey parameter doesn't work as expected

["Denis Magda (JIRA)" <ji...@apache.org>]

Denis Magda created IGNITE-6375:
-----------------------------------

             Summary: CREATE TABLE affinityKey parameter doesn't work as expected
                 Key: IGNITE-6375
                 URL: https://issues.apache.org/jira/browse/IGNITE-6375
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Denis Magda
            Assignee: Vladimir Ozerov
            Priority: Blocker


Start a couple of cluster nodes and preload the data using SQLLine tool and an SQL script as described here:
https://github.com/dmagda/ignite_world_demo

The SQL tables are couple by affinity principle, check the script. However, when I try to execute this query with a JOIN
{code}
SELECT country.name, city.name, MAX(city.population) as max_pop FROM country
    JOIN city ON city.countrycode = country.code
    WHERE country.code IN ('USA','RUS','CHN')
    GROUP BY country.name, city.name ORDER BY max_pop DESC LIMIT 3
{code}

then get a wrong result
{noformat}
United States New York 8008278
United States Los Angeles 3694820
United States Chicago 2896016
{noformat}

The correct result is the following:
{noformat}
China Shanghai 9696300
Russian Federation Moscow 8389200
United States New York 8008278
{noformat}

But you have to force {{non-collocated}} joins to get it. 

All this means that {{affinityKey}} parameter of CREATE TABLE doesn't work properly or there is an issue with DML.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)