Query like this fails:
```sql
select cn from (select cn, count(*) cnt from dt WHERE __time > TIMESTAMP
'2018-09-01 13:00:00' group by cn limit 10)
```
```
{"error":"Unknown exception","errorMessage":"Cannot build plan for query:
select cn from (select cn, count(*) cnt from dt WHERE __time > TIMESTAMP
'2018-09-01 13:00:00' group by cn limit 10)
```
While `*` works:
```sql
select * from (select cn, count(*) cnt from dt WHERE __time > TIMESTAMP
'2018-09-01 13:00:00' group by cn limit 10)
```
Removal of `count(*)` also works:
```sql
select cn from (select cn from dt WHERE __time > TIMESTAMP '2018-09-01
13:00:00' group by cn limit 10)
```
[ Full content available at:
https://github.com/apache/incubator-druid/issues/6293 ]
This message was relayed via gitbox.apache.org for [email protected]
