ApsaraDB for SelectDB:Kernel release notes

Version

Release date

Description

References

26.1.2

August 28, 2026

This version incorporates the major features and fixes from Apache Doris 4.1.3.

[New features]

• Added JDBC catalog support for Dameng databases.

• Added OceanBase (MySQL compatibility mode) as a CDC source for Streaming Jobs.

• Added table-level event-driven cache warmup through the ON TABLES clause for WARM UP COMPUTE GROUP, with INCLUDE and EXCLUDE wildcard filters.

• Added is_valid_utf8 and isValidUTF8 functions for validating UTF-8 strings.

• Added ZSTD-compressed CSV and JSON input for Stream Load and HTTP Stream Load, including group commit loads.

• Added the Iceberg rewrite_manifests procedure to reduce manifest metadata overhead.

• Added LZ4 output compression for Parquet and ORC files written through Iceberg or Hive catalogs.

• Added configurable default Doris roles for LDAP-authenticated users.

• Added the include_delete_sign option so MySQL and PostgreSQL change streams can expose __DORIS_DELETE_SIGN__.

[Improvements]

• Added brute-force fallback for ANN TopN queries to improve result quality for highly selective vector searches.

• Improved distributed aggregation and join performance by choosing fewer and less expensive shuffle-key columns.

• Reduced false query cancellations when reclaimable OS page cache accounts for much of a container's memory usage.

• Changed the default profile_level to 2 so query profiles include detailed per-instance counters by default.

• Improved incremental MySQL and PostgreSQL CDC throughput by keeping each job on a stable execution node.

• Changed S3 endpoints without an explicit scheme to use HTTPS by default.

• INSERT OVERWRITE now removes replaced partitions permanently instead of placing them in the recycle bin.

[Bug fixes]

• Fixed aggregation simplification returning incorrect results when a GROUP BY expression was not injective.

• Fixed multiple co-located window functions returning incorrect results when a TopN filter was pushed below incompatible PARTITION BY keys.

• Fixed recursive CTE queries hanging when several scan instances ran on the same execution node.

• Fixed NOT IN subqueries losing null-aware anti-join behavior during rewrite.

• Fixed from_base64 and to_base64 corrupting memory for large inputs.

• Fixed full-text searches over inverted indexes spanning multiple segments potentially skipping postings when block-WAND optimization was used.

Apache Doris 4.1.3

26.1.1

July 31, 2026

This version incorporates the major features and fixes from Apache Doris 4.1.2.

[New features]

• Added recursive common table expressions through WITH RECURSIVE for hierarchical and graph queries.

• Added the UNNEST syntax to expand arrays and other nested values into rows.

• Added the json_each and json_each_text table-valued functions to expand JSON objects into key-value rows.

• Added the array_cross_product function to compute the Cartesian product of multiple arrays.

• Added the murmur_hash3_128 scalar function, the exponential_moving_average aggregate function, and DataSketches HLL aggregate functions.

• Added current_database as an alias for the existing database() function.

• Added disk-based IVF vector indexes for vector search workloads where the index exceeds available memory.

• Added DOC mode for Variant columns that stores raw documents during ingestion and defers sub-column extraction to reduce write costs for wide JSON documents.

• Added NestedGroup support for Variant columns and the NESTED search operator to query arrays of nested objects without flattening them first.

• Added conditional caching to reuse repeated filter results on unchanged table data.

• Added row-level UPDATE, DELETE, and MERGE INTO support for Iceberg V2 and V3 tables, along with Iceberg V3 delete vectors and row lineage reads.

• Added Iceberg JDBC catalog, sorted writes, static partition overwrite, and the publish_changes procedure.

• Added Paimon JDBC catalog and SQL operations for creating and dropping Paimon databases and tables.

• Added CREATE TABLE, DROP TABLE, and INSERT INTO support for the MaxCompute external catalog.

• Added Parquet metadata table-valued functions to inspect row groups, column statistics, and other file metadata through SQL.

• Added INSERT INTO support for file table-valued functions to export query results to HDFS or S3.

• Added the cdc_stream table-valued function to read MySQL and PostgreSQL change streams and use them as data sources for streaming jobs.

• Added OIDC authentication for MySQL clients, including authentication integration, role mappings, and the information_schema.role_mappings table.

• Added AWS MSK IAM authentication for Kafka Routine Load jobs.

[Improvements]

• Improved stability of large joins, aggregations, and sorts by allowing intermediate data to spill across multiple tiers when memory is constrained.

• Reduced latency and memory usage for complex join and aggregation queries by aggregating rows earlier and improving plans for duplicate and simple aggregations.

• Improved ORDER BY ... LIMIT queries on indexed columns through index-backed lazy materialization, and improved execution of CASE WHEN, explode, and posexplode.

• Improved throughput and memory efficiency for large table scans by adaptively adjusting scan batch sizes.

• Improved repeated Parquet queries by reusing decompressed data pages, and improved Paimon query performance through the native reader.

• Extended MySQL and PostgreSQL CDC streaming jobs with custom table mappings, snapshot-only sync, PostgreSQL schema change handling, column exclusion, and additional PostgreSQL data types.

• Added explicit start offsets, compute group selection, structured failure reasons, and per-job latency and progress metrics for streaming jobs.

• Improved full snapshot CDC reliability for large or data-skewed tables by preventing in-progress tasks from being timed out and retried.

• Changed window_funnel to use the more memory-efficient v2 implementation by default, while keeping the previous implementation as window_funnel_v1. In FIXED mode, rows that do not match any funnel condition no longer break the sequence, so affected queries may return longer funnel chains after upgrade.

• Extended multiple aggregate and array functions to accept TIMESTAMPTZ values, and extended max_by and min_by to support complex types.

• Exposed unified runtime statistics and task progress for running queries.

• Added compute groups to MTMV refresh task output so that refresh placement can be inspected directly.

• Reduced memory pressure during row-store ingestion and parsing of sparse Variant documents.

• Added a default limit of 768 buckets per partition. CREATE TABLE and ADD PARTITION now reject partitions that exceed this limit.

[Fixed issues]

• Fixed an issue where *_diff functions, datediff on zero dates, and convert_tz during daylight saving time transitions produced inconsistent results between compile-time constant folding and runtime execution.

• Fixed an issue where coalesce returned NULL when a nullable float argument contained an unused NaN value and subsequent arguments provided the expected non-NULL result.

• Fixed an issue where runtime filters produced incorrect results when pushed through the nullable side of an outer join.

• Fixed an issue where query plans reused pre-aggregation state across different join branches, potentially producing incorrect plans when branches required different aggregation behavior.

• Fixed an IndexOutOfBoundsException that occurred when querying SELECT * views created on external tables after the source table had columns added and metadata refreshed.

• Fixed an issue where tokenize returned only one row when its first argument was a constant and the query scanned multiple input rows.

• Fixed an issue where json_contains treated numerically equal JSON values (such as 1 and 1.0) as distinct, and where duplicate array candidates produced incorrect containment results.

• Fixed an issue where enable_insert_strict silently altered INSERT statement casting behavior. Insert row filtering and enable_strict_cast now operate independently.

• Fixed an issue where COM_RESET_CONNECTION cleared the selected database and partially reset other session states, potentially breaking pooled MySQL connections after reset.

• Fixed a meet invalid precision: real_precision=0 error when querying legacy DecimalV2 data written by Doris versions earlier than 2.1.0.

• Fixed an issue where MATCH rejected aliased Variant dot-subcolumns (such as msg.trace_id) and where nested Variant searches bound to the wrong inverted index.

• Fixed an issue where array subscripts and element_at returned NULL when applied to Variant sub-paths that the optimizer had pruned.

• Fixed an issue where sparse Variant paths inferred incorrect element types for mixed-type arrays and lost TIMESTAMPTZ values during serialization.

• Fixed a Compaction TAPE_ERROR failure when nullable NestedGroup Variant data had visible nested behavior as NULL or empty.

• Fixed low or zero recall for IVF and PQ vector indexes when training used only a subset of segments, and ANN range search state leaking across segments. Segments with insufficient training rows now skip index creation instead of failing writes.

• Fixed an issue where window_funnel v2 returned incorrect longest chains in DEDUPLICATION and FIXED modes when subsequent starting events produced longer valid sequences.

• Fixed an issue where MTMV skipped required refresh work after excluded_trigger_tables changes, and partitioned MTMV checks failed when the caller provided an immutable excluded table set.

• Fixed an issue where PostgreSQL CDC jobs with multiple tables and offset=initial permanently lost changes during the snapshot phase, and where same-named tables in matching patterns caused Duplicate key failures.

• Fixed an issue where cdc_stream offsets did not survive FE checkpoints, potentially causing recovered jobs to resume from incorrect source positions.

• Fixed a broken pipe error in Stream Load when redirect request bodies were not consumed, and a backend selection failure when backend ID differences exceeded integer range.

• Fixed an issue where JSON ingestion mapped STRUCT sub-fields by position instead of by name when input field order differed from the table schema.

• Fixed an issue where workload group queries were resumed while their memory reservations were still unavailable, potentially bypassing expected pause behavior.

• Fixed an issue where client queries hung until socket timeout when FE leader switching caused the final result packet to be lost.

• Fixed a null pointer failure in transactional INSERT INTO ... VALUES in multi-compute-group deployments when a backend from another compute group was selected.

• Fixed an issue where a failed ADD PARTITION left stale partition metadata when partial catalog updates had completed before rollback began.

• Fixed an issue where vertical compaction ran out of memory on large rowsets due to incorrect available buffer capacity calculation.

• Fixed an issue where migrated Iceberg tables without explicit write format properties were read with incorrect file formats, and Iceberg writes ignored the configured object-store.path data location.

• Fixed incorrect COUNT DISTINCT results on Iceberg V3 row lineage tables and missing required Iceberg field IDs in position delete file writes.

• Fixed Iceberg write failures when partition values contained characters requiring URL encoding, and large sorted Iceberg write failures after spilling intermediate data.

• Fixed an issue where the SQL Server JDBC catalog omitted built-in schemas in SHOW DATABASES when using newer Microsoft JDBC drivers.

• Fixed a No suitable driver found failure when Paimon JDBC system table queries were run through the native Paimon scan path.

Apache Doris 4.1.2

26.1.0

-

This version incorporates the major features and fixes from Apache Doris 4.1.0.

[New features]

• Added IVF vector index and IVF_ON_DISK (DiskANN) for trillion-scale vector search.

• Added search() function with BM25 scoring, nested search, and multi-field strategies, compatible with Elasticsearch query_string syntax.

• Added Segment V3 storage format for wide-table metadata optimization.

• Added Variant Sparse Sharding and DOC mode for sparse-column and high-write-throughput scenarios.

• Added Iceberg V2/V3 full read/write support (UPDATE, DELETE, MERGE INTO) and Paimon JDBC catalog with SQL DDL.

• Added UNNEST, WITH RECURSIVE, ASOF JOIN, and TIMESTAMPTZ type.

• Added MERGE INTO standard SQL and multi-level Spill to Disk.

Apache Doris 4.1.0

Version

Release date

Description

References

5.0.6

(26.0.6)

August 29, 2026

This version incorporates the major features and fixes from Apache Doris 4.0.8.

[Improvements]

• The Nereids distributed planner is now consistently enabled after an upgrade from a 3.x version.

• Raised the default value of autobucket_min_buckets from 1 to 3 to improve the parallelism and data distribution of auto-bucketed tables.

• Reduced the latency of lightweight information_schema.tables queries on large OLAP tables.

• Improved S3 wildcard scans by pushing expandable path prefixes down to object listing.

• Routine Load now records the first source error and masks sensitive Kafka properties.

• Hardened JDBC catalog driver_url validation to reject path traversal and schemeless paths that are not plain JAR file names.

[Bug fixes]

• Fixed inverted index queries returning zero rows after an upgrade because of mixed physical index formats.

• Fixed high-concurrency asynchronous Stream Load waiting indefinitely after a Group Commit plan creation failure.

• Fixed the filter-ratio check failing for INSERT INTO ... SELECT, DELETE, and UPDATE when ordinary query predicates filtered out all scanned rows.

• Fixed from_base64 and to_base64 corrupting memory for large inputs.

• Fixed Arrow Flight SQL queries against external tables crashing during split batch retrieval.

• Fixed full-text search possibly skipping posting lists when the block-WAND optimization was applied to inverted indexes that span multiple segments.

Apache Doris 4.0.8

5.0.5

(26.0.5)

August 3, 2026

This version incorporates the major features and fixes from Apache Doris 4.0.7.

[Security]

• Added support for FE authentication mode. Authentication is enabled by default to improve cluster security.

• Removed support for PL/SQL stored procedures to improve security.

• Fixed a potential remote command execution issue with JDBC JAR files.

• Fixed a potential SSRF issue in the _stream_load_forward interface.

[New features]

• Added the require_partition_filter option to SQL blocking rules. When a partitioned table (internal tables and Hive tables) is queried, the query is rejected if it does not contain a usable partition predicate.

• Added compute group selection and visibility for manual MTMV refreshes. The current compute group is applied to the refresh task and exposed in tasks("type" = "mv").

• Added per-job metrics for Routine Load and streaming insert jobs. The metrics carry job_id and job_name labels, so you can inspect the row count, byte count, progress, lag, and task results of an individual job.

• Added FE metrics for the total connection limit and the per-user connection limit.

• Added ldap_default_roles, which lets LDAP-authenticated users obtain the configured Doris roles in addition to the roles mapped from their LDAP groups.

[Improvements]

• Exact-match and brace-expanded S3 file paths can now be accessed with only the s3:GetObject permission. Wildcard paths still require the s3:ListBucket permission.

• Improved Hive query planning: when row counts are estimated from file listings, the metadata cache is now populated to avoid repeated Hive Metastore access within the same query.

• Reduced peak memory usage when loading into row-store tables by serializing MemTable flushes in bounded batches.

• Reduced the risk of out-of-memory failures during the first vertical compaction of wide tables by sizing batches based on the actual row width of the table.

• Reduced unnecessary query cancellations in cgroup and Kubernetes deployments by counting reclaimable file-backed pages as available memory.

• Routine Load lag is now refreshed on every scheduling round. Kafka Routine Load tasks that use isolation.level=read_committed now interpret positive lag as records that are not yet committed, and back off repeated zero-row retries.

• Session variables that are set per query through SET_VAR are now recorded in the changed_variables field of the audit log.

• CREATE USER and ALTER USER statements that are stored in the audit log now have their passwords masked.

• Scan node IDs are now included in Nereids physical plan output, which makes plan diagnostics easier to correlate.

• Made the timeout mechanism for large from-to streaming job snapshot tasks progress-aware, so that tasks that are still scanning are no longer repeatedly killed and retried.

• Improved the recovery of from-to streaming jobs when the source or the CDC client stalls, by throttling control requests, timing out idle setup attempts, releasing stale readers after a task failure, and including the first rejected row in task errors.

• INSERT OVERWRITE now permanently deletes the replaced partitions instead of moving them to the recycle bin. After this operation, the replaced partitions cannot be recovered from the recycle bin.

• Reduced SDK retry latency after object storage throttling. S3 SlowDown and Azure HTTP 429 responses are now surfaced directly to higher layers instead of being retried inside the SDK.

• Cloud SHOW PARTITIONS output now reports StorageMedium as OBJECT_STORAGE and ReplicaAllocation as NULL.

[Bug fixes]

• Fixed a null pointer error for transactional INSERT INTO ... VALUES in multi-compute-group deployments when backend selection returned a backend outside the current compute group.

• Fixed the unknown tablet to append data error for auto-detect INSERT OVERWRITE when concurrent batches routed rows before the replacement partitions were fully open.

• Fixed loads that use load_to_single_tablet=true losing single-tablet routing when automatic partitions were created at runtime.

• Fixed enable_insert_strict incorrectly changing the cast semantics of INSERT statements. enable_insert_strict and enable_strict_cast now control row filtering and cast strictness independently.

• Fixed truncated-file errors for compressed files that are loaded through the http_stream table-valued function when schema inference ran before the complete compressed request body had arrived.

• Fixed some HTTP/1.1 Stream Load clients receiving BrokenPipeError or ConnectionResetError when uploading through an FE redirect, especially with chunked uploads or high network latency.

• Fixed the Comparison method violates its general contract error in Stream Load when the difference between backend IDs exceeded the 32-bit integer range.

• Fixed a possible BE crash during a load when multiple local sinks reused a shared delta writer after the sink that created it had already finished.

• Fixed DELETE operations waiting unnecessarily or failing to commit when some replica push tasks failed after a majority had already succeeded.

• Fixed a null pointer error in automatic-partition loads when dynamic partitioning or retention_count cleanup concurrently dropped a newly created partition.

• Fixed BE load row and byte counters temporarily decreasing during automatic-partition loads. Each source row is now counted only once.

• Fixed Cloud schema changes failing repeatedly on retry after compaction because stale base-tablet version metadata was used.

• Fixed KV_TXN_CONFLICT errors when concurrently loading into or committing to the same table, which were caused by table version hint reads creating unnecessary transaction conflicts.

• Fixed a possible BE crash when a failed load asynchronously uploaded its error log to object storage.

• Fixed a possible BE crash for queries that use runtime filters when a pipeline task was resubmitted after the task had started to finalize.

• Fixed Routine Load task renewal racing with scheduler accounting after a task submission failure, which could leave the idle slot count of the scheduler inconsistent.

• Fixed materialized view rewriting over multi-hop outer joins either failing predicate compensation or retaining null-padded rows when an inner join query was rewritten by an outer join materialized view.

• Fixed Aggregate key table queries returning duplicate rows when one join branch contained an aggregate subquery and the pre-aggregation state leaked into sibling scans.

• Fixed UNION DISTINCT returning too few rows when a non-injective cast was pushed below the deduplication operation.

• Fixed nested ORDER BY ... LIMIT ... OFFSET queries returning too many rows when compatible TopN operators were merged and the outer offset was not subtracted from the inner limit.

• Fixed planner failures or incorrect expression binding in set operation queries when DISTINCT TopN or Limit was pushed down, or when single-row UNION merging used different child output layouts.

• Fixed incorrect NULL handling in filters that combine a correlated subquery with other Boolean predicates.

• Fixed outer joins returning incorrect results when a non-null-propagating runtime filter was pushed through the null-generating side of the join.

• Fixed the legacy planner treating distinct IPv4 or IPv6 literals as equal, which could remove predicates from !=, NOT IN, or NOT BETWEEN filters and return extra rows.

• Fixed the optimizer converting topn() to max(), which could return incorrect results because the two functions no longer have equivalent semantics.

• Fixed analysis failures for aggregate expressions such as group_concat(... ORDER BY ...) when the sort expression contained a window function or a scalar subquery.

• Fixed clients waiting until the socket timed out when an FE master switchover caused the actual query result packet to be lost.

• Fixed index-out-of-bounds errors when querying a view that was created with SELECT * after columns were added to the underlying external table and the metadata was refreshed.

• Fixed UnsupportedOperationException during partitioned MTMV refresh and rewrite checks when the set of excluded trigger tables was immutable.

• Fixed a null pointer error when querying information_schema.view_dependency for MTMVs that were created before first-level base view metadata was introduced.

• Fixed correlated scalar subqueries with ORDER BY ... LIMIT 1 silently losing their ordering semantics. This unsupported query shape is now rejected during analysis.

• Fixed convert_tz constant folding and partition pruning using incorrect assumptions during daylight saving time transitions, which could prune partitions that still contained matching rows.

• Fixed TIMESTAMPTZ values that have a negative hour offset, such as -00:30, being rendered with a positive sign.

• Fixed folded datediff results differing from runtime results for zero-date boundary values, and nullable date literals being bound with incorrect nullability during folding.

• Fixed json_contains returning false when the candidate array contained duplicate elements that exist in the target array.

• Fixed array_first and array_last failing to cast Boolean lambda results, and added analysis-time validation when an array_sort lambda has an incorrect number of arguments.

• Fixed retention() corrupting memory and crashing the BE when it was called with more than 32 conditions. Such calls now return a clear analysis error.

• Fixed COUNT(DISTINCT ...) hitting an internal error when its argument was a VARIANT, and multi-argument COUNT(DISTINCT ...) window functions reaching an unsupported execution path. These forms are now rejected during analysis.

• Fixed SEARCH queries that use Lucene syntax on columns without an inverted index reaching an invalid execution path. They are now rejected during analysis with an index-specific error.

• Fixed invalid IPv4 default values being accepted by CREATE TABLE and failing only on a subsequent INSERT or load. They are now rejected when the table is created.

• Fixed isNull(column) = 1 failing to resolve to a valid function expression.

• Fixed SQL Server and Oracle JDBC catalog queries failing when Boolean or bit predicates were pushed down as TRUE or FALSE instead of 1 or 0.

• Fixed Parquet reads hitting type comparison errors or crashing the BE when the previous row group used dictionary filtering and the next group returned strings.

• Fixed a null pointer error in Iceberg COUNT(*) pushdown when a snapshot that was written by compaction or by a replace operation omitted the total record count and the delete counters.

• Fixed queries on migrated Iceberg tables reading ORC files as Parquet when the format property was missing, and allowed supported columns to be queried when another Iceberg column uses the unsupported varint type.

• Fixed the Invalid location, missing authority error in Iceberg Hadoop catalog queries when data file paths omitted the URI scheme and relied on the fs.defaultFS of the catalog.

• Fixed FE checkpoint or edit log replay failures after Azure resources were persisted without a runtime type discriminator.

• Fixed the BE crashing during Avro schema inference through the JNI reader, because the schema retrieval path did not provide a runtime state.

• Fixed COM_RESET_CONNECTION clearing the selected database and leaving other session state behind. Pooled MySQL-compatible clients now keep the selected database when session variables, user variables, prepared statements, transactions, and temporary tables are reset.

• Fixed SHOW FULL PROCESSLIST returning incomplete or incorrect frontend connection rows in multi-FE deployments, and using the wrong privilege when an administrator inspected the sessions of other users.

• Fixed SHOW VARIABLES WHERE changed = 1 reporting transient internal one-time values as user-changed.

• Fixed metadata lookups failing for external system table names that contain a dollar sign, because MySQL-compatible pattern conversion rejected $ instead of treating it as a literal.

• Fixed SHOW TABLET DIAGNOSIS reporting spurious disk pressure and replica version errors in compute-storage decoupled deployments.

• Fixed information_schema.backend_tablets reading inconsistent rowset metadata when it raced with compaction.

• Fixed SU sessions losing the effective role override during privilege checks, and backend selection failing when the target user had no explicit resource tag.

• Fixed streaming insert jobs remaining permanently in the PAUSED state when a delayed BE commit callback arrived after the FE task had timed out.

• Fixed PostgreSQL streaming jobs failing or producing shifted values when a snapshot contained timestamps or historical dates from before 1970, and long snapshot chunks being marked as complete before all batches had been read.

• Fixed from-to PostgreSQL streaming jobs reading a transaction repeatedly when a single transaction spanned more than one polling interval. The offset is now committed only after the transaction has been read completely.

• Fixed a null pointer error in multi-table streaming snapshots when the change event queue contained DML from different captured tables.

• Fixed CANCEL TASK on a non-streaming job being rejected when unrelated streaming jobs existed in the same job manager.

Apache Doris 4.0.7

5.0.4

(26.0.4)

July 5, 2026

This version incorporates the major features and fixes from Apache Doris 4.0.6.

[New features]

• Added the mmhash3_u64_v2 hash function.

• Added the json_object_flatten scalar function to flatten nested JSON objects.

• Added lambda comparator support for array_sort, allowing arrays to be sorted with custom comparison logic.

• Added support for Iceberg REST catalog and S3 Tables IAM role authentication.

• Added the ability to track Compaction tasks through system tables.

[Improvements]

• Changed the default trigger threshold for time-series Compaction from 2,000 files to 1,000 files, enabling earlier merging of time-series data.

• Reduced memory pressure during load and write workloads by adaptively adjusting write buffer sizes, allowing online tuning of flush thread pools, and releasing unused write memory earlier.

• Improved Compaction isolation in compute-storage separated mode, reducing resource contention between user workloads and background Compaction.

• Reduced optimizer planning overhead for complex queries and improved row count estimation after partition pruning.

• Reduced statistics collection overhead by skipping excessively long string columns.

• Improved the accuracy of audit logs and metrics for partition near-limit reporting, histogram labels, internal query states, and prepared statement QPS.

[Fixes]

• Fixed an issue where INTERSECT and EXCEPT queries lost NULL rows when predicates were pulled up during planning.

• Fixed an issue where count(null) was incorrectly treated as count(*), and where count queries with MATCH_ALL expressions failed due to NoSuchElementException.

• Fixed an issue where materialized view rewrite returned incorrect results when partition pruning removed always-true predicates, and where rewrite merged partitions that were not needed by the query.

• Fixed an issue where queries with multiple input fragments that received both broadcast and hash-partitioned inputs in the same fragment failed with Rows mismatched! Data may be lost.

• Fixed errors in pushing projections into UNION or reusing CTE producer statistics in queries.

• Fixed an issue where the no_use_cbo_rule hint was silently ignored.

• Fixed multiple TIMESTAMPTZ and datetime issues, including LEAD and LAG preserving incorrect types, daylight saving time (DST) gap and fold handling, elapsed time calculations, and TopN runtime predicate support.

• Fixed an issue where converting scientific notation strings to Decimal produced incorrect results.

• Fixed incorrect results from allow_zero_date and changed from_olap_string to return NULL instead of throwing an exception when datetime parsing fails.

• Fixed integer type inference and parameter parsing issues with user variables.

• Fixed an issue where ALTER VIEW definitions containing COMMENT were not synchronized to follower FEs. This issue only affects multi-FE deployments.

• Fixed an issue where views based on Variant columns returned incorrect results when the view definition lost Variant subfield references.

• Fixed invalid alias rewriting in view definitions and missing colUniqueId for view columns under lazy materialization.

• Fixed an issue where Variant Compaction failed on keyless tables with Variant columns containing uid 0.

• Fixed an issue where Variant subcolumns were lost after row-store partial column updates, and an issue with reading legacy single-part point key subcolumn paths.

• Fixed an issue where duplicate Variant JSON paths retained the wrong occurrence position. The first occurrence is now retained.

• Fixed an issue where Broker Load only loaded the first file when multiple file paths were specified.

• Fixed an issue where PostgreSQL CDC streaming jobs silently dropped DML after task restarts.

• Fixed issues with offset, statistics, and property recovery for streaming jobs after FE checkpoint or restart.

• Fixed Routine Load failures caused by null Kafka metadata state and BE restarts during coordination.

• Fixed CSV parsing issues when files with UTF-8 BOM used enclose characters.

• Fixed an issue where INSERT job statistics disappeared from SHOW LOAD after FE restart, and a memory leak in InsertLoadJob when jobs were in PENDING state.

• Fixed an issue where JDBC catalog type mapping was incorrect when the Doris-compatible MySQL endpoint's version_comment did not contain "Doris".

• Fixed an issue where TVF column aliases were lost in cross-JDBC catalog queries.

• Fixed an issue where Hive DATE values were shifted due to timezone handling in external readers.

• Fixed an issue where predicate filters were skipped when external file scans mixed native and JNI readers.

• Fixed incompatibility between SHOW PARTITIONS and external catalogs or the partitions TVF.

• Fixed an out-of-bounds crash when generating partition columns for Iceberg or Paimon tables.

• Fixed Parquet read and write issues involving INT96 timestamp output, Page V2 encoding, and conditional checks.

• Fixed an issue where TVFs failed when the generated Thrift message exceeded the configured size limit.

• Fixed multiple cloud schema change failures involving local rowset replacement, version gaps, and delete bitmap capture.

• Fixed a race condition between initial dynamic partition setup and concurrent CREATE MATERIALIZED VIEW.

• Fixed an issue where CANCEL ALTER with an empty job list was treated as canceling all rollup jobs.

• Fixed an issue where SHOW TABLET failed when no database was selected, where SHOW BACKENDS field order was mismatched, and where partition cache version was missing from SHOW PROC.

• Fixed BE crashes during concurrent OLAP scans, shared hash table Hash Join with runtime filter release, and IO callback cleanup.

• Fixed Arrow Flight SQL query execution issues when returning results from BE, client IP authentication issues, and Arrow string size handling issues.

Apache Doris 4.0.6

5.0.3

(26.0.3)

April 22, 2026

This version incorporates the major features and fixes from Apache Doris 4.0.5.

[New features]

• Added support for MATCH projection as a virtual column of an inverted index.

• Added PrefixQuery, PhrasePrefixQuery, and UnionPostings support.

• Added BM25 scoring and phrase-level BM25 scoring for inverted index queries.

• Changed the default search mode from standard to lucene.

• Added LDAPS support.

[Bug fixes]

• Fixed query cache inconsistency caused by variant subcolumns.

• Fixed set operations crashing when the data volume exceeded 4 GB.

• Fixed an LDAP injection vulnerability by applying proper escaping.

• Fixed a load memory regression.

• Fixed a file cache concurrency crash.

Apache Doris 4.0.5

5.0.2

(26.0.2)

April 1, 2026

This version incorporates the major features and fixes from Apache Doris 4.0.4.

[New features]

• Enabled the all_manifests system table for Iceberg tables.

• Added flexible partial update support for Routine Load.

• Implemented the expire_snapshots stored procedure for Iceberg tables.

• Added the PREVIOUS_DAY function and more INTERVAL time units.

• Added three spatial functions: ST_Distance, ST_GeometryType, and ST_Length.

• Added support for creating multiple tokenizer indexes on the same column.

• Added support for schema changes on complex types in Iceberg external tables.

[Improvements]

• Improved password validation to align with the MySQL STRONG policy.

• Optimized the performance of the Parquet dictionary decoder.

• Added support for dynamically modifying rate limiter configurations.

• Added support for synchronizing PostgreSQL partitioned tables in streaming jobs.

Apache Doris 4.0.4

5.0.0

December 31, 2025

This version incorporates the major features and fixes from Apache Doris 4.0.0.

[New features]

• Added HNSW-based vector index with SQ8/SQ4 quantization and pre-filtering.

• Added AI Functions library for direct LLM integration via SQL.

• Added search() function with BM25 scoring and Elasticsearch-style syntax.

• Added ICU, IK, and Basic tokenizers with custom tokenizer support.

• Added Spill to Disk for Hash Join, Aggregation, and Sort operators.

• Added CAST normalization (BNF) and TRY_CAST function.

• Added TopN lazy materialization for multi-table and external table queries.

• SQL Cache enabled by default with 100x parsing performance improvement.

Apache Doris 4.0.0

Version

Release date

Description

References

4.1.9

August 25, 2026

This version incorporates the major features and fixes from Apache Doris 3.1.4.

[New features]

• Window functions now support COUNT(DISTINCT ...) and SUM(DISTINCT ...), which can be used together with PARTITION BY.

• ARRAY columns can now be used in ORDER BY and GROUP BY.

• UPDATE and DELETE support ORDER BY and LIMIT.

• Added the FORMAT, FORMAT_NUMBER, and PARSE_DATA_SIZE functions.

• Added support for reading deletion vectors of Iceberg v3 tables.

• Transparent Data Encryption (TDE) now supports Ranger KMS, Google Cloud KMS, and Azure KMS, with key rotation.

• Added graceful shutdown, which reduces the number of in-flight queries that are canceled by FE/BE state transitions during a rolling restart.

[Improvements]

• Group Commit Stream Load can be forwarded to multiple follower FEs in round-robin mode to offload the master FE.

• Hardened JDBC catalog driver_url validation to reject path traversal.

• Removed PL/SQL stored procedure and package capabilities. The CALL built-in command is not affected.

• The default value of three experimental storage and write optimizations (enable_adaptive_write_buffer_size, enable_packed_file, and skip_writing_empty_rowset_metadata) is changed from true to false.

[Bug fixes]

• Fixed an excessively large file_cache_ttl_seconds value overflowing on the BE and turning the TTL cache into a regular cache.

• Fixed urgent loads possibly preempting the lock when a non-lightweight schema change was performed on a Cloud Unique Key Merge-on-Write table.

• Fixed Iceberg equality deletes possibly being applied to the wrong column after a field was renamed.

• Fixed incorrect scanner mapping when JDBC query results use column aliases.

• Fixed subqueries that carry NULL semantics possibly being incorrectly rewritten into an ordinary hash condition.

Apache Doris 3.1.4

4.1.8

August 2, 2026

[Security]

• Added support for FE authentication mode. Authentication is enabled by default to improve cluster security.

• Removed support for PL/SQL stored procedures to improve security.

• Fixed a potential remote command execution issue with JDBC JAR files.

• Fixed a potential SSRF issue in the _stream_load_forward interface.

[New features]

• Statistics collection now skips string columns whose single-row length exceeds 1,024 bytes by default, preventing large text columns from slowing down or blocking ANALYZE. The task still completes, and the skip reason is visible in the analysis results.

• Iceberg REST Catalog and S3Tables Catalog can now access AWS resources through IAM roles, temporary credentials, or credentials providers, reducing the need to manually maintain long-term access keys.

• OBS parallel file systems can now be accessed through the native OBS file system, preventing external table or object storage read/write failures in scenarios not supported by the S3-compatible protocol.

• Routine Load now supports per-task observability of consumed rows, error rows, throughput, progress, lag, and abort counts, making it easier to identify latency or anomalies in individual load tasks.

• Added metrics for asynchronous materialized views and query rewrite, enabling observation of MV refresh task status and MV rewrite duration during the query planning phase.

• The MTMV refresh task list now displays which compute group a task is running on, making it easier to troubleshoot resource group selection and refresh failures.

• Automatic partitioning and dynamic partitioning now allow more partitions by default and expose warning metrics when the partition count exceeds 80% of the limit, helping you detect approaching partition limits earlier.

[Improvements]

• Auto-bucketing tables now create a minimum of 3 buckets by default, mitigating the insufficient parallelism caused by having only 1 bucket for small tables or underestimated estimates.

• The Cloud write path now reduces the number of empty rowset metadata entries and object storage files by default, lowering metadata and object storage overhead after high-frequency small-batch writes.

• File Cache now reads cached files directly by default and adds capacity limits for the background LRU update queue and shadow queue, reducing cache hit read path overhead and preventing excessive memory usage from LRU events.

• After configuring File Cache TTL, subsequent writes no longer refresh the cache expiration time for the entire tablet, making the cache lifecycle more consistent with table or tablet creation time semantics.

• When the same table warm-up task is submitted repeatedly, duplicate pending jobs are now reused or rejected. Asynchronous rowset warmup no longer blocks queries or subsequent scheduling, and warm-up metrics are more accurate.

• Routine Load using Kafka read_committed now reduces idle retries when encountering uncommitted transactions, and lag reporting is more timely.

• Stream Load Group Commit and Broker Load write paths now reduce unnecessary initialization and parameter passing, lowering import overhead and preventing unsupported scenarios from incorrectly using sink node memtables.

• BE memory usage and rowset metadata size are reduced in high-concurrency import, row-store write, Cloud packed file write, and large rowset metadata scenarios.

• When object storage returns SlowDown rate-limiting errors, the system now fails fast by default, preventing excessive automatic retries from amplifying object storage pressure.

• During query troubleshooting, scan nodes, query summaries, and internal query failure states can now be more easily correlated through plan, profile, and audit logs.

• Prometheus histogram metric labels are no longer lost, allowing related latency metrics to be correctly aggregated and alerted by their original label dimensions.

• DataWorks lineage logs are now automatically cleaned based on configuration, preventing log files from accumulating over long-running periods.

[Bug fixes]

• Fixed an issue where residual partition metadata after a failed new partition creation on Cloud tables caused subsequent partition creation, query, or metadata sync anomalies.

• Fixed an issue where high-concurrency transaction commits or high-concurrency ADD/DROP PARTITION on Cloud tables were more likely to encounter KV_TXN_CONFLICT.

• Fixed an issue where Cloud recycling of dropped tablets containing empty segment rowsets got stuck, preventing tablet/index metadata from being cleaned up for extended periods.

• Fixed an issue where Cloud recycling deleted tablet KV entries even when some objects failed to delete, potentially leaving orphaned objects or preventing correct retry of subsequent recycling.

• Fixed an issue where version gaps or legacy compaction rowsets after Cloud schema change affected queries, delete bitmaps, or subsequent compaction.

• Fixed an issue where low-write tablets could not trigger time-series compaction by time threshold for extended periods after BE restart or migration.

• Fixed issues with File Cache cleanup during restart, direct cleanup, or abnormal directory states that caused statistical anomalies, residual cache items, or cleanup failures. The HTTP cleanup interface is now uniformly executed asynchronously.

• Fixed an issue where slow or chunked Stream Load clients encountered broken pipe during FE redirect, and prevented redirect URL rewriting from causing path or parameter anomalies with special characters.

• Fixed an issue where Stream Load or BE selection logic could not select the correct BE or caused import failures when BE ID differences were large.

• Fixed an issue where transaction writes in Cloud multi-compute group scenarios were routed to incorrect backends, causing INSERT or transaction import failures.

• Fixed an issue where parallel exports caused file deletion or export failures when multiple BEs cleaned the target path simultaneously. Local file system exports now reject unsupported delete_existing_files.

• Fixed an issue where writes failed immediately after Insert Overwrite auto-created replacement partitions because the partitions were not yet routable.

• Fixed an issue where row and byte statistics were duplicated during automatic partition table imports, causing metrics or displayed values to be inflated.

• Fixed an issue where queries containing outer join, mark anti join, pre-aggregation join, or random/unique functions could return incorrect results after specific rewrites.

• Fixed an issue where combined queries involving TopN, aggregation, datetime predicates, alias functions, user variables, and null checks produced incorrect results or parsing failures in specific scenarios.

• Fixed an issue where materialized view rewrite could select incorrect partitions or return incorrect results in outer join or partition compensation scenarios.

• Fixed an issue where view definitions were incorrectly rewritten when creating or querying views containing aggregate aliases, star expansion, or Variant subfields, causing query failures or incorrect results.

• Fixed result errors or unsupported semantics being accepted in point queries, multi-layer projections, IPv4/IPv6 literal comparisons, and complex type literal comparisons.

• Fixed an issue where JSONB functions could cause BE crashes when encountering invalid input or unknown types.

• Fixed an issue where Variant content was lost after row-store partial updates, and where reading Variant subfields with dots written by older versions failed after upgrade.

• Fixed an issue where Variant duplicate JSON path behavior was unstable, and where JSONB/Variant was incorrectly used as hash distribution columns, causing subsequent write or query anomalies.

• Fixed an issue where TLS/mTLS configuration required a CA, where PEM multi-certificate chain loading was incomplete, or where SNI host check failed when accessing HTTPS via IP.

• Fixed an issue where queries using CTE could bypass Ranger column-level permission checks.

• Fixed an issue where LDAP authentication failed when usernames or passwords contained special characters, and where LDAP connection exceptions could block new connections.

• Fixed an issue where Arrow Flight SQL could not obtain the real remote IP for client IP-based authentication or access control.

• Fixed an issue where queries or INSERT INTO ... SELECT executed via SU/proxy and forwarded to master obtained {location=invalid} when the SU target user lacked resource_tags.location or UserProperty, causing default tag replicas to be filtered and reporting tablet ... has no queryable replicas.

• Fixed an issue where skip_catalog_priv_check had an overly broad scope, causing some catalog operations to bypass permission checks.

• Fixed an issue where the KeyCache background thread accessed freed resources during BE shutdown or restart in TDE scenarios, causing crashes.

• Fixed an issue where connection pool reuse of MySQL connections left residual user variables, temporary tables, prepared statements, or transaction states.

• Fixed an issue where SQL parsing failed when table names, aliases, or CTE names used "su".

• In Cloud mode, executing the unsupported ADMIN SET REPLICA VERSION now directly returns an unsupported error, preventing incorrect modification of replica version information that does not apply to Cloud.

• Fixed an issue where SHOW TABLET failed when USE db was not executed, and where SHOW BACKENDS result columns were misaligned with headers.

• Fixed an issue where queries could still select replicas marked for deletion after the user deleted them, causing query failures or instability.

• Fixed an issue where Iceberg RestCatalog could not use temporary credentials when accessing S3-compatible storage such as OSS, OBS, COS, or MinIO.

• Fixed an issue where schema retrieval failed with newer SQLServer JDBC drivers, causing external catalog query anomalies.

• Fixed an issue where Hive external table row count cache was incomplete, and where external file systems that were cache-evicted were still used, causing query or transaction failures.

• Fixed an issue where string or binary column decoding was incorrect, or where group reader failed when reading some Parquet external files.

• Fixed an issue where concurrent scans of the same tablet during lightweight schema change or rowset state changes could cause BE crashes.

• Fixed an issue where INSERT error message formatting was abnormal, and where FE exceptions occurred when Routine Load retrieved Kafka metadata with null values.

• The select @@version return value no longer contains the "selectdb" or "velodb" strings.

Apache Doris 3.1.4

4.1.7

May 26, 2026

[Fixes]

• Cache and cache warm-up: Improves the stability of cache warm-up and remote Peer Read, reducing the impact of scaling, hot/cold data tiering, and remote data reads on import and query performance. Enhances observability of the warm-up progress.

• File cache: Enhances the stability of the file cache during cleanup, error retries, and partial hit scenarios. This reduces the risk of cache pollution, error amplification, BE crashes, and cache space expansion.

• Compaction: Enhances observability and troubleshooting for compaction tasks. Improves the retry mechanism after conflicts and increases stability in schema change and Merge-on-Write (MOW) scenarios.

• Data writing: Improves the stability of write operations such as Stream Load, Broker Load, Group Commit, and INSERT/DELETE. Enhances the reliability of task status after error recovery and restarts.

• Write resource control: Reduces peak memory usage during large-volume writes and high-concurrency flush scenarios, enhancing write stability and resource control.

• Query correctness: Fixes multiple query accuracy issues, preventing incorrect results or errors in scenarios involving complex SQL, set operations, short-circuit queries, and function calculations.

• External data sources and object storage: Improves compatibility for connecting to object storage and external data sources. Enhances configuration adaptation and read stability for scenarios involving S3, OSS, Azure, JDBC, Hive, ORC, and CSV.

• Security and authentication: Improves cloud-based certificate authentication, encrypted communication, permission control, and license management. Enhances security configuration usability and reduces the risk of sensitive information exposure.

• Cloud metadata and transactions: Enhances the stability of cloud metadata, transactions, and version synchronization. Improves the reliability of transaction aborts, version reporting, issue diagnosis, and inter-service request tracing.

• Backup, recovery, and snapshots: Improves the stability of backup, recovery, and snapshot processes. Reduces view recovery errors and snapshot generation failures.

• DDL and metadata changes: Improves stability in metadata change scenarios, including view alterations, automatic partitioning, and materialized view creation.

• Observability and diagnostics: Enhances diagnostic capabilities for scenarios involving cache warm-up, compaction, Routine Load, compute groups, BDBJE, and Kubernetes deployments, providing more complete and intuitive information for troubleshooting online issues.

Apache Doris 3.1.4

4.1.6

May 9, 2026

[Fixes]

• Improves the stability of packed file uploads to prevent data write failures caused by exceptions during writes to object storage.

Apache Doris 3.1.4

4.1.5

April 20, 2026

[Fixes]

• Enhanced cross-compute group read cache capability: On a cache hit, cross-group read requests can bypass remote object storage access, which reduces network overhead from origin-pulls. This version also achieves production-grade stability for the Colocate table Peer Read mechanism, improving overall query latency and cross-node bandwidth utilization.

• Improved Profile/bvar metrics system: Adds Peer Read hit rate, cross-group routing topology, and latency breakdown dimensions for precise performance bottleneck identification. Exposes direct query and dynamic intervention interfaces for Peer Cache candidate node status, improving cache topology management.

• Optimized file cache concurrency model: Enhances state machine stability under heavy query loads and high-concurrency scenarios, suppresses resource contention, and reduces abnormal state triggers and performance jitter.

• Hardened BE node fault tolerance: Eliminates potential memory leak and thread deadlock risks under high-concurrency file cache access and abnormal boundary conditions, which reduces the risk of unexpected backend process crashes.

• Fine-grained read-side cache lifecycle management: Introduces per-job dynamic cache retention policies for INSERT INTO SELECT tasks, preventing persistent cache pollution from long-tail queries.

• Improved large-scale sorting performance: Optimizes sort engine memory scheduling logic and adds a session-level variable to control full sort buffer to dynamically adjust full sort memory thresholds based on workload characteristics.

• Accelerated schema change version reclamation: Optimizes the metadata version cleanup mechanism, shortens invalid version retention periods, mitigates version accumulation, and reduces I/O and compute overhead in subsequent compaction stages.

• Converged INSERT OVERWRITE cleanup logic: Adopts a deterministic partition path overwrite strategy to eliminate legacy path discrepancies and ensure strong consistency between metadata and physical storage state.

• Strengthened FE communication and transaction boundary fault tolerance: Optimizes inter-node RPC timeout backoff and retry mechanisms, and unifies error code semantics for cloud-native distributed transaction exception scenarios, making client interactions more predictable and retry-friendly.

• Implemented tiered log noise reduction: Filters redundant debug information and optimizes critical event aggregation logic, ensuring log output during troubleshooting focuses precisely on core exception chains and system state transitions.

• Adjusted Tablet scheduling policy baseline: Disables the "active Tablet priority scheduling" feature by default after upgrades, shifting system load balancing to a conservative and stable mode and reducing hotspot skew risk under extreme loads.

• Optimized Recycler lightweight scheduling: Reduces the default execution weight and metadata scan granularity of the background recycler, which alleviates lock contention and memory overhead at the metadata layer in high-watermark clusters.

Apache Doris 3.1.4

4.1.4

April 15, 2026

[Fixes]

• Enhances cloud compaction throughput and wide-table organization capabilities, with more conservative default policies to reduce additional jitter from new features after an upgrade.

• Improves stability during scaling, hot/cold tiering, and cache warm-up phases, with more conservative balancing logic to reduce hotspot scheduling anomalies and task accumulation risks.

• Improves the robustness of file cache hit-and-recovery logic, reducing cache pollution, missed retries, and error amplification in query and import scenarios.

• Reduces the risk of stuck transactions, version inconsistencies, and upgrade interruptions, improving upgrade stability.

• Reduces memory pressure in large-scale clusters, with safer recovery paths to lower the risk of OOM errors, accidental data deletion, or increased FDB pressure from recycling in exceptional cases.

• Improves availability with special network, certificate, authentication, and endpoint configurations for Azure/S3, reducing external storage connection issues.

• Improves stability for connections to Paimon, Hudi, Iceberg, and Ozone, reducing external catalog hangs, read errors, and compatibility issues.

• Improves the accuracy of various query plans and function results. Fixes result anomalies in some set operations, Nereids optimizations, and time zone-related queries.

• Enhances stability for import, overwrite, schema change, and Routine Load scenarios, reducing write failures and unintended task cancellations.

• Improves SQL compatibility and permission checking accuracy, enabling more stable connections through proxies or in scenarios with complex request headers.

• Adds DataWorks lineage integration and fixes compatibility issues with the 3.1 branch, reducing plugin integration risks.

• Allows configurable Pinyin tokenization for Chinese search scenarios, providing more flexible search capabilities.

• You can now directly use KMS to manage transparent encryption master keys in Alibaba Cloud environments.

• Enhances stability for semi-structured data scenarios using Variant/Struct types, supporting more sub-columns and reducing compaction and type conversion anomalies.

• Covers more global time zone scenarios and improves export format flexibility.

• Enhances the observability of cloud transactions, recycling, Routine Load, and interactions with the meta service.

Apache Doris 3.1.4

4.1.3

March 11, 2026

[New features]

Supports all features of Apache Doris 3.1.4.

[Fixes]

• Adds a small file merging feature that reduces object storage API calls, lowering storage costs and improving import performance. This feature is disabled by default.

• Improves transaction commit performance in high-concurrency import scenarios, reducing import latency.

• Fixes multiple issues that could cause query failures, BE crashes, or memory leaks.

• Improves metadata query performance, optimizes the cluster startup and upgrade experience, and enables automatic job recovery after compute group switchovers.

• Supports multi-version FDB clients to improve deployment compatibility.

• Fixes multiple file cache crashes and capacity inaccuracies to improve cache stability.

• Fixes a risk of accidental data deletion by the data recycler, improving recycling security.

• Fixes several import issues, including partial updates in Routine Load, path columns in Broker Load, and format-based imports with Copy Into.

• Fixes multiple optimizer issues that could cause query hangs, incorrect results, or execution failures.

• Fixes issues related to materialized view rewrite selection. Disables materialized views with conditions on the value column of Merge-on-Write (MOW) tables to prevent data errors.

• Supports more flexible AWS authentication methods. Fixes issues with hanging external table queries and connections to S3-compatible storage such as MinIO and COS.

• Fixes partition and cache-related issues for Iceberg, Hive, and Paimon. Improves Hive partition pruning performance.

• Fixes a memory leak in JDBC catalog. Adds support for the Elasticsearch (ES) flatten type.

• Optimizes import memory usage with automatic backpressure in high-memory scenarios to prevent OOM errors.

• Fixes data correctness issues related to compaction and schema change.

• Enhances storage credential security to prevent sensitive information leaks and Server-Side Request Forgery (SSRF) attacks.

• Fixes issues with SQL parsing compatibility, SQL blacklist failure on restart, missing monitoring metrics, and data type compatibility.

• Adds the array_flatten and QUANTILE_STATE_TO/FROM_BASE64 functions.

• Audit Log now supports SQL fingerprints and encryption for easier analysis and security compliance.

• Improves JDK 17 compatibility.

Apache Doris 3.1.4

4.1.2

January 21, 2026

[Fixes]

• Optimizes view creation logic in specific scenarios to improve the SQL user experience.

• Optimizes the temporary resource management mechanism to improve long-term system stability.

• Optimizes the cache capacity management strategy to improve resource utilization efficiency.

• Optimizes the execution performance and stability of Routine Load in update scenarios.

• Optimizes the transaction recovery process to enhance system robustness.

• Adds transaction-related monitoring metrics to enhance observability.

• Optimizes the FE service encoding configuration to improve system compatibility and stability.

• Optimizes task scheduling and resource recovery efficiency in cloud environments.

Apache Doris 3.1.3

4.1.1

December 17, 2025

[New features]

Supports all features of Apache Doris 3.1.3.

Apache Doris 3.1.3

4.1.0-beta

November 1, 2025

[New features]

Supports all features of Apache Doris 3.1.1.

Apache Doris 3.1.1

Version

Release date

Description

References

4.0.12

August 1, 2026

[Security]

• Added support for FE authentication mode. Authentication is enabled by default to improve cluster security.

• Removed support for PL/SQL stored procedures to improve security.

• Fixed a potential remote command execution issue with JDBC JAR files.

Apache Doris 3.0.8

4.0.11

March 25, 2026

[Enhancements and fixes]

• Improves stability when querying CSV files with quoted headers by using S3 TVFs, preventing field parsing errors.

• Enhances S3 TVF compatibility with more CSV escape formats, reducing preprocessing costs.

• Increases the success rate of importing compressed JSON data and prevents Stream Load failures.

• Improves the stability of exporting data to OSS, preventing backup and export failures caused by authentication errors.

• Ensures that semantically identical SQL queries return consistent results, which reduces the risk of misjudgment in production environments.

• Fixes errors in some date and time-related SQL queries.

• Improves cluster stability in high-concurrency and complex import scenarios, reducing BE crashes.

• Reduces the risk of batch query timeouts in long-running clusters.

• Fixes an issue where some complex queries triggered BE crashes, which improves query stability.

• Improves the stability of queries that involve remote reads and the file cache and reduces BE core dumps.

• Improves FE stability under high traffic, which allows it to support larger business workloads.

• Prevents the unknown inverted index format 0 error during queries and improves query availability.

• Improves stability in complex write scenarios, such as INSERT OVERWRITE.

• Reduces the risk of abnormal FE restarts and complete service outages.

• Allows TVF queries on system libraries to automatically wake up the cluster, which reduces no available backends errors.

• Increases the success rate of instance type changes and scale-ins and reduces the time that operations remain stuck.

• Accelerates the rebalancing process after a scale-out, which enables faster business recovery.

• Clarifies the meaning of monitoring metrics to improve the assessment of remote scanning workloads.

• Optimizes the out-of-the-box default configuration for high-concurrency and import scenarios in production environments.

Apache Doris 3.0.8

4.0.10

January 11, 2026

[Fixes]

• Fixes an issue where incorrect URL information was truncated during an INSERT import.

• Fixes a GROUPING_PREFIX error that occurred in specific aggregate query scenarios.

• Fixes occasional failures in insert overwrite operations caused by rowset conflicts.

• Fixes an issue where materialized view creation failed.

• Fixes an execution plan error that occurred because a Java User-Defined Function (UDF) prevented consecutive project operations from merging.

• Fixes an error in the pipeline parallelism calculation during TVF import.

• Fixes abnormal memory usage during UDF execution.

• Fixes the unknown load_id error during the import process.

• Optimizes the tablet rebalance scheduling mechanism by enabling dynamic adjustment of the scheduling period, which improves efficiency.

• Fixes data skew after a version upgrade.

• Fixes a window function matching error in partition top-N scenarios.

• Fixes an issue where the parameter constant check for lead/lag functions was too strict in certain scenarios.

• Fixes an issue where Routine Load jobs reported errors after an upgrade.

• Fixes an issue where the behavior of the JSON_EXTRACT function changed after an upgrade.

• Fixes an issue with predicate pushdown optimization in scenarios that involve multiple left joins.

• Fixes an issue where the start value of an AUTO INCREMENT column was incorrect.

• Fixes a BE crash caused by column type conversion.

• Optimizes the predicate pushdown strategy for random sampling scenarios.

• Fixes an issue where JSON_EXTRACT returned null when processing an array.

• Fixes an issue where the substring function failed in specific scenarios.

• Fixes an inference error in join reordering that caused query failures.

• Fixes an issue with detecting ambiguous column names in multi-table joins.

• Improves the accuracy of error messages for failed imports.

• Fixes an issue where an overwrite operation performed by using a MaxCompute catalog caused data loss and adds debug logs.

• Fixes a bug that caused the observer to stop when a get version call failed during meta service rate limiting.

• Fixes a null pointer exception that occurred during Routine Load task assignment.

• Fixes BE stability issues.

• Fixes a deadlock in BE JVM metrics collection.

• Fixes an issue where a DLF-based Paimon catalog failed to read from OSS HDFS.

• Fixes an issue where the max_tablet_size log printed a table ID instead of a tablet ID.

Apache Doris 3.0.8

4.0.9

November 25, 2025

[Fixes]

• Fixes an issue where UDFs occasionally reported a NoClassDefFoundError.

• Fixes an issue where queries on Iceberg external tables without partition columns returned incorrect results.

Apache Doris 3.0.8

4.0.8

October 27, 2025

[Fixes]

• Fixes an issue where INSERT jobs failed when they queried an Elasticsearch catalog.

• Fixes an issue where an invalid JSON path caused a core dump.

Apache Doris 3.0.8

4.0.7

September 26, 2025

[New features]

Supports all features of Apache Doris 3.0.8.

Apache Doris 3.0.8

4.0.6

September 15, 2025

[New features]

Supports all features of Apache Doris 3.0.6.

[Enhancements]

• Optimizes the startup process for file cache upgrades to accelerate the upgrade from version 3.0.x to 4.0.x.

• Improves query performance and availability in multi-cluster scenarios.

• Adds status checks during rowset preparation and commit to improve availability.

• Improves the performance of top-N queries.

[Fixes]

Fixes a query performance issue caused by premature tablet cache cleanup.

Apache Doris 3.0.6

4.0.5

July 14, 2025

[New features]

Supports all features of Apache Doris 3.0.4 and Apache Doris 3.0.5.

[Enhancements]

Improves availability by resolving an issue of premature data recycling.

[Fixes]

Fixes an inverted index core dump issue that occurred when you upgrade from version 4.0.4 to 4.0.5.

• Apache Doris 3.0.4

• Apache Doris 3.0.5

4.0.4

December 6, 2024

[New features]

• Supports all features of Apache Doris 3.0.3.

• Supports arrays of the text field type in JDBC catalog.

• Supports the timestamp field type in MaxCompute catalog.

[Enhancements]

• Improves query performance by resolving an issue of high CPU consumption during the segment loading process.

• Reduces fluctuations in query response times by optimizing the file cache policy.

• Optimizes the file cache recycling mechanism.

• Improves information_schema query performance.

• Optimizes the metadata lock mechanism.

• Optimizes the delete bitmap lock mechanism.

• Improves memory management for Compressed Class Space.

• Enhances security by removing an interface that posed a Server-Side Request Forgery (SSRF) risk.

• Improves the performance of Audit Log statistics.

• Improves the performance of window functions in paginated queries.

• Improves the performance of time-series compaction for Merge-on-Write (MOW) tables.

[Fixes]

• Fixes an issue where modifying the disable_auto_compaction property of a MOW table could make table data unavailable.

• Fixes an issue where imports to MOW tables failed during peak hours.

• Fixes several Routine Load issues, including data loss, job stalls, and transaction commit failures.

• Fixes an issue where Routine Load jobs were paused and reported errors after the instance access module was restarted.

• Fixes an issue where Group Commit could fail.

• Fixes an issue where queries scanned more data after an instance was upgraded to kernel version 4.0.4.

• Fixes an issue where point queries that used precompilation did not return a result set.

• Fixes an issue where duplicate values could appear in the primary key field of a table that used the Unique model.

• Fixed an issue where reclaiming stale rowset caused cache misses, which increased query response time.

• Fixes an inconsistency between the results from Change Data Capture (CDC) partial column updates and from Stream Load wide table joins.

• Fixes an issue that caused core dumps on multiple cluster nodes.

• Fixes a metadata exception that occurred when an asynchronous materialized view read data from a table across clusters.

• Fixes an issue with data quality validation when you write to an Auto Partition table by using insert overwrite.

• Fixes an issue where insert overwrite caused a write error.

• Fixes an issue that incorrectly blocked insert overwrite operations on the same table.

• Fixes an issue where an error URL was not provided for insert into select operations that failed due to data quality issues.

• Fixed an issue where a stmtId overflow caused a Prepared Statement exception in high-concurrency point query scenarios.

• Fixes a RUNTIME_ERROR caused by an uninitialized state when you execute the ConvertTz function after you upgrade to version 4.0.4.

• Fixes an issue that caused slow cluster restarts.

• Fixes an issue where the NOT operator did not take effect in short-word matching.

• Fixes an issue with compaction recovery after a schema change.

• Fixes a data import error and a version limit exceeded issue caused by empty partitions after a schema change.

• Fixes a JDBC connection leak issue.

• Fixes a PostgreSQL (PG) catalog connection leak issue.

• Fixes an issue where partition pruning for MaxCompute catalog did not take effect.

• Fixes an issue where the local file cache size dropped sharply due to premature eviction of cached data.

• Fixes an issue where SQL Cache caused incorrect results.

• Fixes a calculation error in the split_part function.

• Fixes a compatibility issue with field naming rules.

• Fixes a query latency issue caused by multiple threads waiting for a spinlock.

• Fixes an issue where cluster nodes went offline abnormally due to transient network jitters.

• Fixes an issue where queries briefly reported a COMPUTE_GROUPS_NO_ALIVE_BE error.

• Fixes an issue where the window_funnel function did not support high-precision timestamp columns.

• Fixes a query planning timeout issue.

• Fixes a core dump issue in explode_variant_array.

• Fixes an issue where queries missed the materialized view.

• Fixes an issue where error log URLs were too long to be accessed.

Apache Doris 3.0.3

4.0.3

October 11, 2024

[New features]

• Supports all features of Apache Doris 3.0.2.

• Supports large transaction imports. This feature is disabled by default.

[Enhancements]

• Disables java_udf by default.

• Optimizes the top n query performance in logging scenarios.

• Improves point query performance through short-circuit evaluation.

• Improves tablet pruning to enhance query performance.

[Fixes]

• Fixes an issue where replaying the catalog could cause a backend instance to fail to start.

• Fixes an issue where the Audit Log component failed after an upgrade from SelectDB Core 3.0.x to 4.0.x.

• Fixes an issue where default compute cluster permissions were restricted after an upgrade to SelectDB Core 4.0.2.

• Fixes an issue where constant folding that uses a Remote Procedure Call (RPC) might cross compute clusters.

• Fixes an issue where a compute cluster could not be found when an SQL statement is forwarded.

• Fixes a core dump issue that is caused by a null pointer in the compaction delete bitmap.

• Fixes an issue where a full compaction could not be triggered for a MOW table when its delete bitmap was too large.

• Fixes an issue where materialized views defined by select * failed to build.

Apache Doris 3.0.2

4.0.2-beta

August 25, 2024

[New features]

• Supports all features of Apache Doris 3.0.1.

[Fixes]

• Fixes an issue where import performance could degrade after a large number of import failures when the same label was used for imports.

• Fixes an issue where a cluster scale-out could cause an instance version upgrade to get stuck.

• Fixes a memory leak issue with the runtime filter.

Apache Doris 3.0.1

4.0.1-beta

July 9, 2024

[New features]

• Supports upgrading SelectDB Core from version 3.0.x (x >= 9) to 4.0.x.

• Supports all features of Apache Doris 3.0.0.

[Fixes]

• Fixes an issue where a backend instance restart was required to restore cluster permissions after an upgrade from SelectDB Core 3.0.9.

• Fixes an issue where inverted index queries could get stuck.

Apache Doris 3.0.0

4.0.0-beta

May 15, 2024

[New features]

• Supports multi-table materialized views (MTMVs), which provide transparent rewriting, automatic refresh, materialization from external to internal tables, and direct queries. Based on this capability, MTMVs can now be used for data warehouse layering, job scheduling, and data processing.

• Introduces the Variant and IP data types and enhances a range of analytical functions to simplify the storage and analysis of complex and semi-structured data.

• Supports auto-incrementing columns, automatic partitioning, and server-side batch request submission (Group Commit), improving efficiency for large-scale and real-time data writes.

• Introduces a high-speed data read interface based on Arrow Flight, which increases data transfer efficiency by up to 100 times. This feature is ideal for data science and other large-scale data read scenarios.

• Supports all features of Apache Doris 2.1.0.

[Enhancements]

• Significantly improves out-of-the-box query performance and delivers good performance without manual tuning. This version also further improves the performance of complex SQL queries, achieving a performance increase of over 100% on the TPC-DS 1 TB benchmark and delivering industry-leading query speeds.

• Significantly improves data lake analytics performance, delivering 4 to 6 times the performance of Trino and Spark. This version also introduces compatibility with multiple SQL dialects, enabling seamless migration from your existing systems to ApsaraDB for SelectDB.

Apache Doris 2.1.0