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, [email protected] < [email protected]> 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 <[email protected]> > *Date:* 2014-12-05 23:28 > *To:* [email protected] > *CC:* dev <[email protected]> > *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, [email protected] < > [email protected]> 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
