SeonghwanMoon created PHOENIX-1269:
--------------------------------------
Summary: Support Count on derived table (group by count with
having clause)
Key: PHOENIX-1269
URL: https://issues.apache.org/jira/browse/PHOENIX-1269
Project: Phoenix
Issue Type: Bug
Reporter: SeonghwanMoon
Sequence
1. create table test (a integer not null primary key, b integer, c integer);
2. upsert into table values ( 1,2,3);
3. select count(1) from (select a from test group by a having sum(b) > 3);
Error: Complex nested queries not supported (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)