|author||Rohan Garg <email@example.com>||Fri Jul 23 20:57:19 2021 +0530|
|committer||GitHub <firstname.lastname@example.org>||Fri Jul 23 20:57:19 2021 +0530|
Fix left join SQL queries with IS NOT NULL filter (#11434) This PR fixes the incorrect results for query : SELECT dim1, l1.k FROM foo LEFT JOIN (select k || '' as k from lookup.lookyloo group by 1) l1 ON foo.dim1 = l1.k WHERE l1.k IS NOT NULL (in CalciteQueryTests) In the current code, the WHERE clause gets removed from the top of the left join and is pushed to the table foo leading to incorrect results. The fix for such a situation is done by : Converting such left joins into inner joins (since logically the mentioned left join query is equivalent to an inner join) using Calcite while maintaining that the druid execution layer can execute such inner joins. Preferring converted inner joins over original left joins in our cost model
Druid is a high performance real-time analytics database. Druid's main value add is to reduce time to insight and action.
Druid is designed for workflows where fast queries and ingest really matter. Druid excels at powering UIs, running operational (ad-hoc) queries, or handling high concurrency. Consider Druid as an open source alternative to data warehouses for a variety of use cases. The design documentation explains the key concepts.
Manage your cluster with ease. Get a view of your datasources, segments, ingestion tasks, and services from one convenient location. All powered by SQL systems tables, allowing you to see the underlying query for each view.
If you would like to contribute documentation, please do so under
/docs in this repository and submit a pull request.
Community support is available on the druid-user mailing list, which is hosted at Google Groups.
Chat with Druid committers and users in real-time on the
#druid channel in the Apache Slack team. Please use this invitation link to join the ASF Slack, and once joined, go into the
Please note that JDK 8 is required to build Druid.
For instructions on building Druid from source, see docs/development/build.md
Please follow the community guidelines for contributing.
For instructions on setting up IntelliJ dev/intellij-setup.md