phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maryann Xue <maryann....@gmail.com>
Subject Re: Re: Phoenix-136 did not support aggregate queries with derived tables in from clause
Date Sat, 06 Dec 2014 04:09:47 GMT
This is actually listed as a different issue in JIRA:
https://issues.apache.org/jira/browse/PHOENIX-944

This is now fixed on the master branch, and will be available in 4.3
release.

On Fri, Dec 5, 2014 at 9:29 PM, sunfl@certusnet.com.cn <
sunfl@certusnet.com.cn> wrote:

> Hi, Maryann
> It did recheck the 4.1 version and got the same error messages.
> I checked the error message in the following code:
> https://github.com/apache/phoenix/blob/4.2/phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java
>
> and found that the count (groupby) query use case would fail with SQLFeatureNotSupportedException.
> and then throwing the error message.
>
> Does this mean that inner query with groupby while outer query with count
> (1) would not been supported ? The reason I am trying this feature is that
> we are expecting to get groups count after groupby query. Noting that in
> mysql or oracle this kind of query works well.
>
> Is there any available alternative approach to get the results using the
> current sql support? If so, please kindly tell me.
>
> Thanks,
> Sun.
> ------------------------------
> ------------------------------
>
> CertusNet
>
>
> *From:* Maryann Xue <maryann.xue@gmail.com>
> *Date:* 2014-12-05 23:28
> *To:* user@phoenix.apache.org
> *CC:* dev <dev@phoenix.apache.org>
> *Subject:* Re: Phoenix-136 did not support aggregate queries with derived
> tables in from clause
> 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
>
>


-- 
Thanks,
Maryann

Mime
View raw message