phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "SeonghwanMoon (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-1269) Support Count on derived table (group by count with having clause)
Date Mon, 22 Sep 2014 01:54:33 GMT
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)

Mime
View raw message