You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Maryann Xue (JIRA)" <ji...@apache.org> on 2014/08/05 20:32:11 UTC
[jira] [Commented] (PHOENIX-1010) Derived aggregate query with
outer limit fails to compile
[ https://issues.apache.org/jira/browse/PHOENIX-1010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14086592#comment-14086592 ]
Maryann Xue commented on PHOENIX-1010:
--------------------------------------
I created an equivalent case with aTable as shown belown, but I could not reproduce this.
"SELECT a, s FROM (SELECT a_string a, sum(a_byte) s FROM aTable GROUP BY a_string ORDER BY sum(a_byte)) LIMIT 2"
Was there any error message?
> 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)