Runtime: Support configurable approx/exact behavior for Druid

Open begelundmuller opened this issue 2 years ago • 3 comments

See context in Slack

Oct 03 '23 14:10 begelundmuller

Druid allows this on per query basis using context keys. Go's sql package does not have any concept of adding context keys per statement. Additionally calcite's avatica server's prepare and execute apis does not accept any context level keys.

Jan 02 '24 16:01 pjain1

For the customers needing more precision, one way is to set this as druid cluster level config so approx is not used. druid.sql.planner.useApproximateCountDistinct=false

Jan 03 '24 10:01 pjain1

Once we move to rest api - https://github.com/rilldata/rill-private-issues/issues/136 then we can use per-query context to set this. Adding to backlog for now

Feb 13 '24 10:02 pjain1