Apache Druid 34.0.0 contains over 270 new features, bug fixes, performance enhancements, documentation improvements, and additional test coverage from 48 contributors.
Review the upgrade notes and incompatible changes before you upgrade to Druid {{DRUIDVERSION}}.
If you are upgrading across multiple versions, see the Upgrade notes page, which lists upgrade notes for the most recent Druid versions.
As part of this change, you must now opt-in to using the deprecated index_hadoop task type. If you don't do this, your Hadoop-based ingestion tasks will fail.
To opt-in, set druid.indexer.task.allowHadoopTaskExecution to true in your common.runtime.properties file.
The web console now supports using SET statements to specify query context parameters. For example, if you include SET timeout = 20000; in your query, the timeout query context parameter is set:
SET timeout = 20000;
SELECT "channel", "page", sum("added") from "wikipedia" GROUP BY 1, 2
SQL queries issued to /druid/v2/sql can now include multiple SET statements to build up context for the final statement. For example, the following SQL query results includes the timeout, useCache, populateCache, vectorize, and engine query context parameters:
SET timeout = 20000;
SET useCache = false;
SET populateCache = false;
SET vectorize = 'force';
SET engine = 'msq-dart'
SELECT "channel", "page", sum("added") from "wikipedia" GROUP BY 1, 2
The API call for this query looks like the following:
curl --location 'http://HOST:PORT/druid/v2/sql' \
--header 'Content-Type: application/json' \
--data '{
"query": "SET timeout=20000; SET useCache=false; SET populateCache=false; SET engine='\''msq-dart'\'';SELECT user, commentLength,COUNT(*) AS \"COUNT\" FROM wikipedia GROUP BY 1, 2 ORDER BY 2 DESC",
"resultFormat": "array",
"header": true,
"typesHeader": true,
"sqlTypesHeader": true
}'
This improvement also works for INSERT and REPLACE queries using the MSQ task engine. Note that JDBC isn't supported.
Improved HTTP endpoints
You can now use raw SQL in the HTTP body for /druid/v2/sql endpoints. You can set Content-Type to text/plain instead of application/json, so you can provide raw text that isn't escaped.
You can now configure clones for Historicals using the dynamic Coordinator configuration cloneServers. Cloned Historicals are useful for situations such as rolling updates where you want to launch a new Historical as a replacement for an existing one.
Set the config to a map from the target Historical server to the source Historical:
The clone doesn't participate in regular segment assignment or balancing. Instead, the Coordinator mirrors any segment assignment made to the original Historical onto the clone, so that the clone becomes an exact copy of the source. Segments on the clone Historical do not count towards replica counts either. If the original Historical disappears, the clone remains in the last known state of the source server until removed from the cloneServers config.
When you query your data using the native query engine, you can prefer (preferClones), exclude (excludeClones), or include (includeClones) clones by setting the query context parameter cloneQueryMode. By default, clones are excluded.
As part of this change, new Coordinator APIs are available. For more information, see Coordinator APIs for clones.
Embedded kill tasks on the Overlord (Experimental)
You can now run kill tasks directly on the Overlord itself. Embedded kill tasks provide several benefits; they:
Kill segments as soon as they're eligible
Don't take up tasks slot
finish faster since they use optimized metadata queries and don't launch a new JVM
Kill a small number of segments per task, ensuring locks on an interval aren't held for too long
Skip locked intervals to avoid head-of-line blocking
Require minimal configuration
Can keep up with a large number of unused segments in the cluster
This feature is controlled by the following configs:
druid.manager.segments.killUnused.enabled - Whether the feature is enabled or not (Defaults to false)
druid.manager.segments.killUnused.bufferPeriod - The amount of time that a segment must be unused before it is able to be permanently removed from metadata and deep storage. This can serve as a buffer period to prevent data loss if data ends up being needed after being marked unused (Defaults to P30D)
To use embedded kill tasks, you need to have segment metadata cache enabled.
As part of this feature, new metrics have been added.
You can now configure the Broker service to prefer Historicals on a specific tier. This is useful for across availability zone deployment. Brokers in one AZ select historicals in the same AZ by default but still keeps the ability to select historical nodes in another AZ if historicals in the same AZ are not available.
To enable, set property druid.broker.select.tier to perferred in Broker runtime properties. You can then configure druid.broker.select.tier.preferred.tier to the tier you want each broker to prefer (i.e. for brokers in AZ1, you could set this to the tier name of your AZ1 historical servers).
The Dart query engine now uses the /druid/v2/sql endpoint like other SQL query engines. The former Dart specific endpoint is no longer supported. To use Dart for a query, include the engine query context parameter and set it to msq-dart.
Enabling Dart remains the same, add the following line to your broker/runtime.properties and historical/runtime.properties files:
druid.msq.dart.enabled = true
Additionally, Dart now queries real-time tasks by default. You can control this behavior by setting the query context parameter includeSegmentSource to REALTIME (default) or NONE, in a similar way to MSQ tasks. You can also run synchronous or asynchronous queries.
This section contains detailed release notes separated by areas.
Web console
You can now assign tiered replications to tiers that aren't currently online #18050
You can now filter tasks by the error in the Task view #18057
Improved SQL autocomplete and added JSON autocomplete #18126
Changed how the web console determines what functions are available, improving things like auto-completion #18214
Updated the web console to use the Overlord APIs instead of Coordinator APIs when managing segments, such as marking them as unused #18172
Ingestion
Improved concurrency for batch and streaming ingestion tasks #17828
Removed the useMaxMemoryEstimates config. When set to false, Druid used a much more accurate memory estimate that was introduced in Druid 0.23.0. That more accurate method is the only available method now. The config has defaulted to false for several releases #17936
Streaming ingestion
Multi-stream supervisors (experimental)
You can now use more than one supervisor to ingest data into the same datasource. Use the id field to distinguish between supervisors ingesting into the same datasource (identified by spec.dataSchema.dataSource for streaming supervisors).
When using this feature, make sure you set useConcurrentLocks to true for the context field in the supervisor spec.
Seekable stream supervisors (Kafka, Kinesis, and Rabbit) can no longer be updated to ingest from a different input stream (such as a topic for Kafka). Since such a change is not fully supported by the underlying system, a request to make such a change will result in a 400 error.
json_merge() is now SQL-compliant when arguments are null. The function now returns null if any argument is null. For example, queries like SELECT JSON_MERGE(null, null) and SELECT JSON_MERGE(null, '{}') will return null instead of throwing an error.
You can now perform big decimal aggregations using the MSQ task engine #18164
Changed MV_OVERLAP and MV_CONTAINS functions now aligns more closely with the native inType filter #18084
Improved query handling when segments are temporarily missing on Historicals but not detected by Brokers. Druid doesn't return partial results incorrectly in such cases. #18025
Cluster management
Configurable timeout for subtasks
You can now configure a timeout for index_parallel and compact type tasks. Set the context parameter subTaskTimeoutMillis to the maximum time in milliseconds you want to wait before a subtask gets canceled. By default, there's no timeout.
Using this config helps parent tasks fail sooner instead of being stuck running zombie sub-tasks.
Added the optional taskCountStart property to the lag based auto scaler. Use it to specify the initial task count for the supervisor to be submitted with #17900
Added audit logs for the following BasicAuthorizerResource update methods: authorizerUserUpdateListener, authorizerGroupMappingUpdateListener, authorizerUpdateListener (deprecated) #17916
Added support for streaming task logs to Indexers #18170
Improved how MSQ task engine tasks get canceled, speeding it up and freeing up resources sooner #18095
Metrics and monitoring
Metrics for Historical cloning
The following metrics for Historical cloning have been added:
config/brokerSync/time
config/brokerSync/total/time
config/brokerSync/error
Real-time ingestion metrics
The following metrics for streaming ingestion have been added:
|Metric|Description|Dimensions|
|------|------------|-----------|
|ingest/events/maxMessageGap|Maximum seen time gap in milliseconds between each ingested event timestamp and the current system timestamp of metrics emission. This metric is reset every emission period.|dataSource, taskId, taskType, groupId, tags|Greater than 0, depends on the time carried in event.|
|ingest/events/minMessageGap|Minimum seen time gap in milliseconds between each ingested event timestamp and the current system timestamp of metrics emission. This metric is reset every emission period.|dataSource, taskId, taskType, groupId, tags|Greater than 0, depends on the time carried in event.|
|ingest/events/avgMessageGap|Average time gap in milliseconds between each ingested event timestamp and the current system timestamp of metrics emission. This metric is reset every emission period.|dataSource, taskId, taskType, groupId, tags|Greater than 0, depends on the time carried in event.|
|Metric|Description|Dimensions|
|------|------------|-----------|
|segment/killed/metadataStore/count|Number of segments permanently deleted from metadata store|dataSource, taskId, taskType, groupId, tags|
|segment/killed/deepStorage/count|Number of segments permanently deleted from deep storage|dataSource, taskId, taskType, groupId, tags|
|segment/kill/queueReset/time|Time taken to reset the kill queue on the Overlord. This metric is emitted only if druid.manager.segments.killUnused.enabled is true.||
|segment/kill/queueProcess/time|Time taken to fully process all the jobs in the kill queue on the Overlord. This metric is emitted only if druid.manager.segments.killUnused.enabled is true.||
|segment/kill/jobsProcessed/count|Number of jobs processed from the kill queue on the Overlord. This metric is emitted only if druid.manager.segments.killUnused.enabled is true.||
|segment/kill/skippedIntervals/count|Number of intervals skipped from kill due to being already locked. This metric is emitted only if druid.manager.segments.killUnused.enabled is true.|dataSource, taskId|
Added the description dimension for the task/run/time metric
Added a metric for how long it takes to complete an autoscale action: task/autoScaler/scaleActionTime#17971
Added a taskType dimension to Overlord-emitted task count metrics #18032
Added the following groupBy metrics to the Prometheus emitter: mergeBuffer/used, mergeBuffer/acquisitionTimeNs, mergeBuffer/acquisition, groupBy/spilledQueries, groupBy/spilledBytes, and groupBy/mergeDictionarySize#17929
Changed the logging level for query cancellation from warn to info to reduce noise #18046
Changed query logging so that SQL queries that can't be parsed are no longer logged and don't emit metrics #18102
Changed the logging level for lifecycle from debug to info#17884
As part of this change, you must now opt-in to using the deprecated index_hadoop task type. If you don't do this, your Hadoop-based ingestion tasks will fail.
To opt-in, set druid.indexer.task.allowHadoopTaskExecution to true in your common.runtime.properties file.
#18239
groupBy and topN queries
Druid now uses the groupBy native query type, rather than topN, for SQL queries that group
by and order by the same column, have LIMIT, and don't have HAVING. This speeds up execution
of such queries since groupBy is vectorized while topN is not.
You can restore the previous behavior by setting the query context parameter useLexicographicTopN to true. Behavior for useApproximateTopN is unchanged, and the default remains true.
Removed the IS_INCREMENTAL_HANDOFF_SUPPORTED context reference from supervisors, as incremental publishing has been the default behavior since version 0.16.0. This context was originally introduced to support rollback to LegacyKafkaIndexTaskRunner in versions earlier than 0.16.0, which has since been removed.
useMaxMemoryEstimates config removed
Removed the useMaxMemoryEstimates config. When set to false, Druid used a much more accurate memory estimate that was introduced in Druid 0.23.0. That more accurate method is the only available method now. The config has defaulted to false for several releases.