phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maryann Xue <maryann....@gmail.com>
Subject Re: Phoenix-136 did not support aggregate queries with derived tables in from clause
Date Fri, 05 Dec 2014 15:28:13 GMT
Hi Sun,

Which version of Phoenix are you using? This feature is supported from 3.1
and 4.1. And there is no such error message in Phoenix code base now.


Thanks,
Maryann

On Fri, Dec 5, 2014 at 3:16 AM, sunfl@certusnet.com.cn <
sunfl@certusnet.com.cn> wrote:

> Hi,all
> Notice that PHOENIX-136
> <https://issues.apache.org/jira/browse/PHOENIX-136> has already supported
> derived tables in from clause, however,
> aggregate queries would throw error like the following:
>    Error: Complex nested queries not supported. (state=,code=0)
>
> The example queries are like : SELECT COUNT (1) FROM (SELECT COUNT (1)
> FROM table WHERE 1=1 GROUP BY COL1)
> while we are expecting to get the final results of distinct groups counts.
>
> Is there any mistake that I am missing or taking the correct grammer? If
> so, please corrects me kindly.
> Any available advice will be greately appreciated.
>
> Thanks,
> Sun.
>
> ------------------------------
> ------------------------------
>
>
>


-- 
Thanks,
Maryann

Mime
View raw message