ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Magda (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-6375) CREATE TABLE affinityKey parameter doesn't work as expected
Date Wed, 13 Sep 2017 22:22:00 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-6375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Denis Magda updated IGNITE-6375:
--------------------------------
    Fix Version/s: 2.2

> 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
>    Affects Versions: 2.1
>            Reporter: Denis Magda
>            Assignee: Vladimir Ozerov
>            Priority: Blocker
>             Fix For: 2.2
>
>
> 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)

Mime
View raw message