[ https://issues.apache.org/jira/browse/PHOENIX-6798?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
chenglei reassigned PHOENIX-6798: --------------------------------- Assignee: chenglei > Eliminate unnecessary reversed scan > ----------------------------------- > > Key: PHOENIX-6798 > URL: https://issues.apache.org/jira/browse/PHOENIX-6798 > Project: Phoenix > Issue Type: Bug > Components: core > Affects Versions: 5.1.2 > Reporter: chenglei > Assignee: chenglei > Priority: Major > > Consider following table: > {code} > create table test_table > (group_id integer not null, > keyword varchar not null, > cost integer, > CONSTRAINT TEST_PK PRIMARY KEY (group_id,keyword)) > {code} > when we query the sql : > {code} > select keyword,sum(cost) from test group by keyword order by keyword desc > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)