317brian commented on code in PR #17092: URL: https://github.com/apache/druid/pull/17092#discussion_r1792631399
########## docs/release-info/release-notes.md: ########## @@ -57,46 +57,543 @@ 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. -## Functional area and related changes +### Compaction features + +Druid now supports the following features: + +- Compaction scheduler with greater flexibility and control over when and what to compact. +- MSQ task engine-based compaction for more performant compaction jobs. + +See [Automatic compaction](https://druid.apache.org/docs/latest/data-management/automatic-compaction/) for details. + +Compaction tasks that take advantage of concurrent append and replace is now generally available. + +[#16291](https://github.com/apache/druid/pull/16291) + +### Window functions are GA + +[Window functions](https://druid.apache.org/docs/latest//querying/sql-window-functions.md) are now generally available in Druid's native engine and in the MSQ task engine. + +- You no longer need to use the query context `enableWindowing` to use window functions. [#17087](https://github.com/apache/druid/pull/17087) + +### Concurrent append and replace GA + +Concurrent append and replace is now GA. The feature safely replaces the existing data in an interval of a datasource while new data is being appended to that interval. One of the most common applications of this feature is appending new data (such as with streaming ingestion) to an interval while compaction of that interval is already in progress. + +### Projections (TBC) + +### Low latency high complexity queries using DART + +Distributed Asynchronous Runtime Topology (DART) supports high complexity queries, such as large joins, high cardinality group by, subqueries, and CTEs, commonly found in ad-hoc data warehouse workloads. DART uses multi-threaded workers, in-memory shuffles, and locally cached data to run these high complexity queries with low latency. + +DART is fully compatible with current Druid query shapes and Druid's storage format. + +[#17140](https://github.com/apache/druid/pull/17140) + +### Upgrade-related changes + +See the [Upgrade notes](#upgrade-notes) for more information about the following upgrade-related changes: +- [Array ingest mode now defaults to array](#array-ingest-mode-now-defaults-to-array) +- [Disabled ZK-based segment loading](#zk-based-segment-loading) +- [Removed task action audit logging](#removed-task-action-audit-logging) +- [Removed Firehose and FirehoseFactory](#removed-firehose-and-firehosefactory) +- [Removed the scan query legacy mode](#removed-the-scan-query-legacy-mode) + +### Deprecations + +- Java 8 support is being deprecated and will be removed in 32.0.0. +- Deprecated API `/lockedIntervals` is now removed [#16799](https://github.com/apache/druid/pull/16799) +- [Cluster-level compaction API](#api-for-cluster-level-compaction-configuration) deprecates taskslots compaction API [#16803](https://github.com/apache/druid/pull/16803) + +## Functional areas and related changes This section contains detailed release notes separated by areas. ### Web console +#### Copy query results as SQL + +You can now copy the results of a query as a Druid SQL statement: + + + +When you copy the results of the pictured query, you get the following query: + +```sql +SELECT + CAST("c1" AS VARCHAR) AS "channel", + CAST("c2" AS VARCHAR) AS "cityName", + DECODE_BASE64_COMPLEX('thetaSketch', "c3") AS "user_theta" +FROM ( + VALUES + ('ca', NULL, 'AQMDAAA6zJOcUskA1pEMGA=='), + ('de', NULL, 'AQMDAAA6zJP43ITYexvoEw=='), + ('de', NULL, 'AQMDAAA6zJNtue8WOvrJdA=='), + ('en', NULL, 'AQMDAAA6zJMruSUUqmzufg=='), + ('en', NULL, 'AQMDAAA6zJM6dC5sW2sTEg=='), + ('en', NULL, 'AQMDAAA6zJM6dC5sW2sTEg=='), + ('en', NULL, 'AQMDAAA6zJPqjEoIBIGtDw=='), + ('en', 'Caulfield', 'AQMDAAA6zJOOtGipKE6KIA=='), + ('fa', NULL, 'AQMDAAA6zJM8nxZkoGPlLw=='), + ('vi', NULL, 'AQMDAAA6zJMk4ZadSFqHJw==') +) AS "t" ("c1", "c2", "c3") +``` + +[#16458](https://github.com/apache/druid/pull/16458) + +#### Explore view improvements + +You can now configure the Explore view on top of a source query instead of only existing tables. +You can also point and click to edit the source query, store measures in the source query, +and return to the state of your view using stateful URLs. + +[#17180](https://github.com/apache/druid/pull/17180) + +Other changes to the Explore view include the following: + +- Added the ability to hide all null columns in the record table +- Added the ability to declare certain parameter values as sticky +- Added the ability to expand a nested column into is constituent paths +- Fixed dragging of a VARCHAR column to a measure control +- Fixed filtering on a predefined measure +- Fixed drag over indicator not clearing +- Fixed applying WHERE filter in the grouping table +- Fixed AS "t" was not always added in the grouping table query +- Fixed AGGREGATE function not being evaluated if it was in an ORDER BY + +[#17213](https://github.com/apache/druid/pull/17213) [#17225](https://github.com/apache/druid/pull/17225) [#17234](https://github.com/apache/druid/pull/17234) + +#### Support Kinesis input format + +The web console now supports the Kinesis input format. + +[#16850](https://github.com/apache/druid/pull/16850) + #### Other web console improvements +- You can now search for datasources in the **Datasource** view - previously you had to find them manually [#16371](https://github.com/apache/druid/pull/16371) +- You can now display both raw and formatted JSON in tables, making the data easier to read and troubleshoot [#16632](https://github.com/apache/druid/pull/16632) +- You can now configure the maximum number of tasks through a menu [#16991](https://github.com/apache/druid/pull/16991) +- You can now specify the Delta snapshot version in the web console [#17023](https://github.com/apache/druid/pull/17023) +- Added hooks to customize the workbench view [#16749](https://github.com/apache/druid/pull/16749) +- Added the ability to hide workbench view toolbar in the **Query** view [#16785](https://github.com/apache/druid/pull/16785) +- Added the ability to submit a suspended supervisor using the SQL data loader [#16696](https://github.com/apache/druid/pull/16696) +- Added the ability to configure `serverQueryContext` to set the query context [#16868](https://github.com/apache/druid/pull/16868) +- Added column mapping information to the explain plan [#16598](https://github.com/apache/druid/pull/16598) +- Added the ability to initiate handoff for a supervisor [#16586](https://github.com/apache/druid/pull/16586) +- Added an option to `Use concurrent locks` and moved all insert and replace options to a separate submenu [#16899](https://github.com/apache/druid/pull/16899) +- Added Delta snapshot version [#17023](https://github.com/apache/druid/pull/17023) +- Added the Delta tile to the data loader for SQL-based batch and classic batch ingestion methods [#17160](https://github.com/apache/druid/pull/17160) +- Improved how the web console detects durable storage [#16493](https://github.com/apache/druid/pull/16493) +- Made the following web console improvements: + - Added titles to action menus + - Improved the query-based ingestion counter calculation + - Removed the filter clause on `__time` + - Fixed scrolling in the `loadRules` editor [#16735](https://github.com/apache/druid/pull/16735) +- Restored the default WHERE filter to auto-generated SQL queries [#16608](https://github.com/apache/druid/pull/16608) +- Fixed NPE due to null values in numeric columns [#16760](https://github.com/apache/druid/pull/16760) + ### Ingestion -#### SQL-based ingestion +#### Optimized the loading of broadcast data sources + +Previously all services and tasks downloaded all broadcast data sources. +To save task storage space and reduce task startup time, this modification prevents kill tasks and MSQ controller tasks from downloading unneeded broadcast data sources. All other tasks still load all broadcast data sources. + +The `CLIPeon` command line option `--loadBroadcastSegments` is deprecated in favor of `--loadBroadcastDatasourceMode`. + +[#17027](https://github.com/apache/druid/pull/17027) + +#### General ingestion improvements + +- The default value for `druid.indexer.tasklock.batchAllocationWaitTime` is now 0 [#16578](https://github.com/apache/druid/pull/16578) +- Hadoop-based ingestion now works on Kubernetes deployments [#16726](https://github.com/apache/druid/pull/16726) +- Hadoop-based ingestion now has a Boolean config `useMaxMemoryEstimates` parameter, which controls how memory footprint gets estimated. The default is false, so that the behavior matches native JSON-based batch ingestion [#16280](https://github.com/apache/druid/pull/16280) +- Added `druid-parquet-extensions` to all example quickstart configurations [#16664](https://github.com/apache/druid/pull/16664) +- Added support for ingesting CSV format data into Kafka records when Kafka ingestion is enabled with `ioConfig.type = kafka` [#16630](https://github.com/apache/druid/pull/16630) +- Added logging for sketches on workers [#16697](https://github.com/apache/druid/pull/16697) +- Removed obsolete tasks `index_realtime` and `index_realtime_appenderator` tasks—you can no longer use these tasks to ingest data [#16602](https://github.com/apache/druid/pull/16602) +- Renamed `TaskStorageQueryAdapter` to `TaskQueryTool` and removed the `isAudited` method [#16750](https://github.com/apache/druid/pull/16750) +- Improved Overlord performance by reducing redundant calls in SQL statements [#16839](https://github.com/apache/druid/pull/16839) +- Improved `CustomExceptionMapper` so that it returns a correct failure message [#17016](https://github.com/apache/druid/pull/17016) +- Improved time filtering in subqueries and non-table data sources [#17173](https://github.com/apache/druid/pull/17173) +- Improved `WindowOperatorQueryFrameProcessor` to avoid unnecessary re-runs [#17211](https://github.com/apache/druid/pull/17211) +- Improved memory management by dividing the amount of `partitionStatsMemory` by two to account for two simultaneous statistics collectors [#17216](https://github.com/apache/druid/pull/17216) +- Fixed NPE in `CompactSegments` [#16713](https://github.com/apache/druid/pull/16713) +- Fixed Parquet reader to ensure that Druid reads the required columns for a filter from the Parquet data files [#16874](https://github.com/apache/druid/pull/16874) +- Fixed a distinct sketches issue where Druid called `retainedKeys.firstKey()` twice when adding another sketch [#17184](https://github.com/apache/druid/pull/17184) +- Fixed a `WindowOperatorQueryFrameProcessor` issue where larger queries could reach the frame writer's capacity preventing it from outputting all of the result rows [#17209](https://github.com/apache/druid/pull/17209) +- Fixed native ingestion task failures during rolling upgrades from a version before Druid 30 [#17219](https://github.com/apache/druid/pull/17219) + +### SQL-based ingestion + +#### Optimized S3 storage writing for MSQ durable storage + +For queries that use the MSQ task engine and write their output to S3 as durable storage, uploading chunks of data is now faster. + +[#16481](https://github.com/apache/druid/pull/16481) -##### Other SQL-based ingestion improvements +#### Improved lookup performance -#### Streaming ingestion +Improved lookup performance for queries that use the MSQ task engine by only loading required lookups. This applies to both ingestion and querying. -##### Other streaming ingestion improvements +[#16358](https://github.com/apache/druid/pull/16358) + +#### Other SQL-based ingestion improvements Review Comment: Hey Akshat, we typically don't include bug fixes unless there's a specific reason to. It's just new features/improvements. There are currently some fixes in there that I'll remove as part of the final cleanup. It looks like 16804 and 17141 didn't have the bug labeled applied. Was that intentional? -- 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]
