paul-rogers opened a new issue #11586:
URL: https://github.com/apache/druid/issues/11586
### Affected Version
The Druid version where the problem was encountered.
### Description
Consider the "stock" Wikipedia data source and stock Docker Druid cluster.
Version: 0.21.
The query is designed to identify the number of rows that would result from
building a new roll-up table with just three of the dimensions:
```sql
SELECT COUNT(*)
FROM (
SELECT hr, channel, page, COUNT(*) AS cnt
FROM (
SELECT
DATE_TRUNC('hour', __time) AS hr,
channel,
page
FROM "wikiticker-2015-09-12-sampled"
)
GROUP BY hr, channel, page
)
```
The query returns zero rows.
However, replace the `count(*)` with `*` and we get many rows of results.
(The rows give the expected number of rows per group in the new roll-up
datasource.) Since a `SELECT *` query returns rows, expected the `COUNT(*)` to
count those rows.
A workaround is to use the form which works, and to count the rows in the
client.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
