phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "" <>
Subject Re: Re: Phoenix-136 did not support aggregate queries with derived tables in from clause
Date Sat, 06 Dec 2014 02:29:21 GMT
Hi, Maryann
It did recheck the 4.1 version and got the same error messages. 
I checked the error message in the following code:

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.



From: Maryann Xue
Date: 2014-12-05 23:28
CC: dev
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.


On Fri, Dec 5, 2014 at 3:16 AM, <> wrote:
Notice that 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
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.


View raw message