[
https://issues.apache.org/jira/browse/PHOENIX-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15663737#comment-15663737
]
Yuan Kang commented on PHOENIX-3465:
------------------------------------
some one can help?
> 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
> Labels: bug
>
> 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 below :
> 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)
