phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yuan Kang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3465) order by incorrect when array column be used
Date Tue, 08 Nov 2016 10:20:59 GMT
Yuan Kang created PHOENIX-3465:
----------------------------------

             Summary: order by incorrect when array column be used
                 Key: PHOENIX-3465
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3465
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.8.0
            Reporter: Yuan Kang


when I create a table like that:
create table "TABLE_A"
(
task_id varchar not null,
date varchar not null,
dim varchar not null,
valueArray double array,
dimNameArray varchar array,
constraint pk primary key (task_id, date, dim)
) SALT_BUCKETS = 4, COMPRESSION='SNAPPY';

upsert some data ,when I query a sql blew :

select date, sum(valueArray[16]) as val1
from TABLE_A 
where date = '2016-11-01' and task_id = '4692' order by val1 desc limit 50;"

the result is incorrert.the similer issus was announced be fix in 4.5.0,this issus is happened
in 4.8.0



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message