317brian commented on code in PR #18231: URL: https://github.com/apache/druid/pull/18231#discussion_r2258385237
########## docs/release-info/release-notes.md: ########## @@ -57,63 +57,388 @@ For tips about how to write a good release note, see [Release notes](https://git This section contains important information about new and existing features. +### Hadoop-based ingestion + +Hadoop-based ingestion has been deprecated since Druid 32.0. 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](https://github.com/apache/druid/pull/18239) + +### Use SET statements for query context parameters + +You can now use SET statements to define query context parameters for a query through the [Druid console](#set-statements-in-the-druid-console) or the [API](#set-statements-with-the-api). + +[#17894](https://github.com/apache/druid/pull/17894) [#17974](https://github.com/apache/druid/pull/17974) + +#### SET statements in the Druid console + +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: + +```sql +SET timeout = 20000; +SELECT "channel", "page", sum("added") from "wikipedia" GROUP BY 1, 2 +``` + +[#17966](https://github.com/apache/druid/pull/17966) + +#### SET statements with the API + +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: + +```sql +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 +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. + + [#17937](https://github.com/apache/druid/pull/17937) + +### Cloning Historicals (experimental) + +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: + +``` + "cloneServers": {"historicalClone":"historicalOriginal"} +``` + +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](#coordinator-apis-for-clones). + +[#17863](https://github.com/apache/druid/pull/17863) [#17899](https://github.com/apache/druid/pull/17899) [#17956](https://github.com/apache/druid/pull/17956) + +### 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](#overlord-kill-task-metrics) have been added. + +[#18028](https://github.com/apache/druid/pull/18028) [#18124](https://github.com/apache/druid/pull/18124) + +### Preferred tier selection +You can now configure the Broker service to prefer Historicals on a specific tier. This can help ensure Druid executes queries within the same availability zone if you have Druid deployed across multiple availability zones. + +[#18136](https://github.com/apache/druid/pull/18136) + +### Dart improvements + +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`. + +[#18003](https://github.com/apache/druid/pull/18003) [#18003](https://github.com/apache/druid/pull/18003) + +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. + +[#18076](https://github.com/apache/druid/pull/18076) [#18241](https://github.com/apache/druid/pull/18241) + +### `SegmentMetadataCache` on the Coordinator + +[#17996](https://github.com/apache/druid/pull/17996) [#17935](https://github.com/apache/druid/pull/17935) + ## Functional area and related changes This section contains detailed release notes separated by areas. ### Web console -#### Other web console improvements +- You can now assign tiered replications to tiers that aren't currently online [#18050](https://github.com/apache/druid/pull/18050) +- You can now filter tasks by the error in the Task view [#18057](https://github.com/apache/druid/pull/18057) +- Improved SQL autocomplete and added JSON autocomplete [#18126](https://github.com/apache/druid/pull/18126) +- Changed how the web console determines what functions are available, improving things like auto-completion [#18214](https://github.com/apache/druid/pull/18214) +- Updated the web console to use the Overlord APIs instead of Coordinator APIs when managing segments, such as marking them as unused [#18172](https://github.com/apache/druid/pull/18172) ### Ingestion -#### SQL-based ingestion - -##### Other SQL-based ingestion improvements +- Improved concurrency for batch and streaming ingestion tasks [#17828](https://github.com/apache/druid/pull/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](https://github.com/apache/druid/pull/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. + +[#18149](https://github.com/apache/druid/pull/18149) [#18082](https://github.com/apache/druid/pull/18082) + +##### Supervisors and the underlying input stream + +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. + +[#17955](https://github.com/apache/druid/pull/17955) [#17975](https://github.com/apache/druid/pull/17975) + ##### Other streaming ingestion improvements +- Improved streaming ingestion so that it automatically determine the maximum number of columns to merge [#17917](https://github.com/apache/druid/pull/17917) + + ### Querying +#### Metadata query for segments + +You can use a segment metadata query to find the list of projections attached to a segment. + +[#18119](https://github.com/apache/druid/pull/18119) [#18223](https://github.com/apache/druid/pull/) + +#### `json_merge()` improvement + +`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. + #### Other querying improvements +- You can now perform big decimal aggregations using the MSQ task engine [#18164](https://github.com/apache/druid/pull/18164) +- Changed `MV_OVERLAP` and `MV_CONTAINS` functions now aligns more closely with the native `inType` filter [#18084](https://github.com/apache/druid/pull/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](https://github.com/apache/druid/pull/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. + +[#18039](https://github.com/apache/druid/pull/18039) + +#### Coordinator APIs for clones + +The following Coordinator APIs are now available: + +- `/druid/coordinator/v1/cloneStatus` to get information about ongoing cloning operations. +- `/druid/coordinator/v1/brokerConfigurationStatus` which returns the broker sync status for coordinator dynamic configs. + +[#17899](https://github.com/apache/druid/pull/17899) + #### Other cluster management improvements +- 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](https://github.com/apache/druid/pull/17900) +- Added audit logs for the following `BasicAuthorizerResource` update methods: `authorizerUserUpdateListener`, `authorizerGroupMappingUpdateListener`, `authorizerUpdateListener` (deprecated) [#17916](https://github.com/apache/druid/pull/17916) +- Added support for streaming task logs to Indexers [#18170](https://github.com/apache/druid/pull/18170) +- Improved how MSQ task engine tasks get canceled, speeding it up and freeing up resources sooner [#18095](https://github.com/apache/druid/pull/18095) + ### Data management #### Other data management improvements ### 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.| + +[#17847](https://github.com/apache/druid/pull/17847) + +#### Kafka consumer metrics + +The following metrics that correspond to Kafka metrics have been added: + +| Kafka metric | Druid metric | +|----------------------------|----------------------------------------| +| `bytes-consumed-total` | `kafka/consumer/bytesConsumed` | +| `records-consumed-total` | `kafka/consumer/recordsConsumed` | +| `fetch-total` | `kafka/consumer/fetch` | +| `fetch-rate` | `kafka/consumer/fetchRate` | +| `fetch-latency-avg` | `kafka/consumer/fetchLatencyAvg` | +| `fetch-latency-max` | `kafka/consumer/fetchLatencyMax` | +| `fetch-size-avg` | `kafka/consumer/fetchSizeAvg` | +| `fetch-size-max` | `kafka/consumer/fetchSizeMax` | +| `records-lag` | `kafka/consumer/recordsLag` | +| `records-per-request-avg` | `kafka/consumer/recordsPerRequestAvg` | +| `outgoing-byte-total` | `kafka/consumer/outgoingBytes` | +| `incoming-byte-total` | `kafka/consumer/incomingBytes` | + +[#17919](https://github.com/apache/druid/pull/17919) + +#### Overlord kill task metrics + +|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`| + +[#18028](https://github.com/apache/druid/pull/18028) + +#### New task metrics + +The MSQ task engine and Dart now support the following metrics: + +- `query/time`: Reported by controller and worker at the end of the query. +- `query/cpu/time`: Reported by each worker at the end of the query. + +Additionally, MSQ task engine metrics now include the following dimensions: + +- `queryId` +- `sqlQueryId` +- `engine`: Denotes the engine used for the query, `msq-dart` or `msq-task`. +- `dartQueryId`: (Dart only) +- `type`: Always `msq` +- `dataSource` +- `interval` +- `duration` +- `success` + +[#18121](https://github.com/apache/druid/pull/18121) + +#### Other metrics and monitoring improvements + +- 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](https://github.com/apache/druid/pull/17971) +- Added a `taskType` dimension to Overlord-emitted task count metrics [#18032](https://github.com/apache/druid/pull/18032) +- Added the following groupBy metrics to the Prometheus emitter: `mergeBuffer/used`, `mergeBuffer/acquisitionTimeNs`, `mergeBuffer/acquisition`, `groupBy/spilledQueries`, `groupBy/spilledBytes`, and `groupBy/mergeDictionarySize` [#17929](https://github.com/apache/druid/pull/17929) +- Changed the logging level for query cancellation from `warn` to `info` to reduce noise [#18046](https://github.com/apache/druid/pull/18046) +- Changed query logging so that SQL queries that can't be parsed are no longer logged and don't emit metrics [#18102](https://github.com/apache/druid/pull/18102) +- Changed the logging level for lifecycle from `debug` to `info` [#17884](https://github.com/apache/druid/pull/17884) +- Added `groupId` and `tasks` to Overlord logs [#17980](https://github.com/apache/druid/pull/17980) +- You can now use the `druid.request.logging.rollPeriod` to configure the log rotation period (default 1 day) [#17976](https://github.com/apache/druid/pull/17976) +- Improved metric emission on the Broker to include per-query result-level caching (`query/resultCache/hit` returning `1` means the cache was used) [#18063](https://github.com/apache/druid/pull/18063) + ### Extensions +#### Kubernetes + +- The task runner log now includes the task id for a job and includes a log before a job is created [#18105](https://github.com/apache/druid/pull/18105) + ### Documentation improvements ## Upgrade notes and incompatible changes ### Upgrade notes -#### Front-coded dictionaries +#### Hadoop-based ingestion + +Hadoop-based ingestion has been deprecated since Druid 32.0. 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. -<!--Carry this forward until 32. Then move it to incompatible changes --> +Hadoop-based ingestion deprecated. Use [SQL-based ingestion](../multi-stage-query/index.md) instead of MapReduce or [MiddleManager-less ingestion using Kubernetes](../development/extensions-core/k8s-jobs.md) instead of YARN. -In Druid 32.0.0, the front coded dictionaries feature will be turned on by default. Front-coded dictionaries reduce storage and improve performance by optimizing for strings where the front part looks similar. -Once this feature is on, you cannot easily downgrade to an earlier version that does not support the feature. +[#18239](https://github.com/apache/druid/pull/18239) -For more information, see [Migration guide: front-coded dictionaries](./migr-front-coded-dict.md). +#### `groupBy` and `topN` queries -If you're already using this feature, you don't need to take any action. +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`. + Review Comment: ```suggestion 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`. [#18074](https://github.com/apache/druid/pull/18074) ``` -- 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]
