Comments (7)
was the approximate distinct count
turned off when you ran this query?
from druid.
from druid.
from druid.
can you set druid.sql.planner.useGroupingSetForExactDistinct
to true and see if that fixes the issue? This bug might be same as what's being discussed here - apache/calcite#3735 (comment)
from druid.
Though I am surprised how did this query even work in 25.0.0 without you setting druid.sql.planner.useGroupingSetForExactDistinct
. It would have failed outright.
from druid.
No luck with this setting too :(
Surprisingly as explained above even without this flag or so single aggregation at a time works
from druid.
Looking at your test case I formed query based on it which works.
SELECT
COUNT(DISTINCT "City") FILTER (WHERE ("SampleSaleData"."__time" >= '2022-01-12T00:00:00.000Z') AND ("SampleSaleData"."__time" < '2022-01-13T00:00:00.000Z')) AS "P2-DistinctCities",
COUNT(DISTINCT "City") FILTER (WHERE ("SampleSaleData"."__time" >= '2022-01-05T00:00:00.000Z') AND ("SampleSaleData"."__time" < '2022-01-06T00:00:00.000Z')) AS "P2-DistinctCities"
FROM
SampleSaleData "SampleSaleData"
But this query, very specific to druid. The solution we are building need to work with multiple DB this query is not working with MySQL as well as Snowflake, the queries are built dynamically, so a very specific druid SQL needs to be built. Until now CASE based query was worked with other traditional standard DBs used to work with druid as well.
So overall now this is failure is specifically related to CASE statements with multiple such aggregations
from druid.
Related Issues (20)
- Overlord's CPU continues to occupy 90%
- Exception occurs when Druid executes "keepalive" process: "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure"
- Make the RabbitMQ play nice with the sampler (allowing it to be part of the data loader flow) HOT 1
- Docker compose quick start druid_shared permission error HOT 3
- [DRAFT] 30.0.0 release notes HOT 7
- Coordinator cannot read task logs from Peon
- Query planner is failing to optimize intervals in some cases
- Issue with PostAggregator arrayOfDoublesSketchConstant in latest Druid 29.0.1 HOT 5
- Problem with array, UNNEST and JSON_PARSE HOT 2
- Producing a version of druid which is FIPS compliant
- Result level cache key collisions from utf8 encoding
- Incorrect comparator usage in FinalizingPostAggregators
- Query with JSON_QUERY/JSON_VALUE using parameters across a join fails to be planned
- MemcachedCache#get doesn't ensure it returns the results for the key its asked
- ORC file sampler is not able to identify the date data type
- Assistance testing Druid JDBC driver?
- Druid pac4j extension skipOnFailure doesn't work HOT 1
- Kafka indexing service duplicate key exception in druid_pendingSegments table
- Druid Console cannot open submit supervisor dialog
- Unnecessary Option variable null check
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from druid.