You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Dongming Liang (JIRA)" <ji...@apache.org> on 2015/04/22 00:19:58 UTC

[jira] [Commented] (PHOENIX-505) Optimize MIN(col) when col leads row key

    [ https://issues.apache.org/jira/browse/PHOENIX-505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14505909#comment-14505909 ] 

Dongming Liang commented on PHOENIX-505:
----------------------------------------

Will work on this issue.

> Optimize MIN(col) when col leads row key
> ----------------------------------------
>
>                 Key: PHOENIX-505
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-505
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: James Taylor
>
> We should be able to change an aggregate query to a scan with LIMIT 1 if the only aggregation is MIN(value) when the index is on value ASC and MAX(value) when the index is on value DESC. Might be able to optimize the reverse too, by finding the largest possible value, but need to test this.



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