[jira] [Resolved] (PHOENIX-1010) Derived aggregate query with outer limit fails to compile

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-1010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor resolved PHOENIX-1010.
-----------------------------------

    Resolution: Cannot Reproduce

Can't repro, so closing.

> Derived aggregate query with outer limit fails to compile
> ---------------------------------------------------------
>
>                 Key: PHOENIX-1010
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1010
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: Maryann Xue
>
> Came across this while answering a question on the HBase mailing list. I thought I needed a derived query, but it turns out I didn't.
> The following query:
> {code}
> SELECT u, s FROM (
>     SELECT WEBSITE_URL u, SUM(HIT_COUNT) s 
>     FROM WEBSITE_STATS
>     GROUP BY WEBSITE_URL
>     ORDER BY SUM(HIT_COUNT))
> LIMIT 10;
> {code}
> is really equivalent to this one:
> {code}
> SELECT WEBSITE_URL u, SUM(HIT_COUNT) s FROM WEBSITE_STATS
> GROUP BY WEBSITE_URL
> ORDER BY SUM(HIT_COUNT)
> LIMIT 10;
> {code}
> but the derived one won't currently compile.



--
This message was sent by Atlassian JIRA
(v6.2#6252)