Re: Phoenix-136 did not support aggregate queries with derived tables in from clause

2014-12-05 Thread Maryann Xue
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, su...@certusnet.com.cn su...@certusnet.com.cn wrote: Hi,all Notice that PHOENIX-136

Re: Re: Phoenix-136 did not support aggregate queries with derived tables in from clause

2014-12-05 Thread su...@certusnet.com.cn
Hi,Maryann We are trying the 4.2 release version. I will retry with 4.1 version and let you know if there are still such eroors. Thanks, Sun. CertusNet From: Maryann Date: 2014-12-05 23:28 To: user@phoenix.apache.org CC: dev Subject: Re: Phoenix-136 did not support aggregate queries

Re: Re: Phoenix-136 did not support aggregate queries with derived tables in from clause

2014-12-05 Thread su...@certusnet.com.cn
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