ywyg commented on issue #14485: URL: https://github.com/apache/druid/issues/14485#issuecomment-1609089570
Yes! I download newest druid and ingest_spec like [this](https://github.com/ywyg/note/blob/master/druid_ingest.json),but when I execute SQL like ``` SELECT "channel", COUNT(DISTINCT "page") AS "page", GROUPING(channel) AS "index" FROM "inline_data" GROUP BY ROLLUP(channel) ``` with context `{ "useApproximateCountDistinct": false }` . As you see, the column value of index all is 0. <img width="821" alt="image" src="https://github.com/apache/druid/assets/37090163/3636b0c5-9d47-4518-8f07-a4e9fa29cfdc";> And when config `useApproximateCountDistinct:true`,it's right, <img width="777" alt="image" src="https://github.com/apache/druid/assets/37090163/086569dd-b0aa-49cf-a0cf-500adfee11ff";> I want use grouping and "useApproximateCountDistinct": false together，I don't how to solve it -- 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]
