[
https://issues.apache.org/jira/browse/PHOENIX-1269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
SeonghwanMoon updated PHOENIX-1269:
-----------------------------------
Summary: Support (Sub query)Count on derived table (group by count with
having clause) (was: Support Count on derived table (group by count with
having clause))
> Support (Sub query)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)
