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)
