[
https://issues.apache.org/jira/browse/PHOENIX-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yuan Kang updated PHOENIX-3465:
-------------------------------
Description:
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
was:
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
> 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)
