gonzalezzfelipe commented on issue #12616:
URL: https://github.com/apache/druid/issues/12616#issuecomment-1163442788
I'm facing this problem as well, and I'm not being able to find a work
around it (using SQL). By doing a query that is like the following:
```sql
SELECT
LOOKUP(id, 'lookup_name') AS foo,
GROUPING(LOOKUP(id, 'lookup_name')) AS __grouping__,
COUNT(*) AS "count"
FROM
datasource
GROUP BY GROUPING SET((LOOKUP(id, 'lookup_name')), ())
```
You get all the resulting rows with `1` as grouping, which makes it
impossible to identify the different grouping sets.
--
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]
