v1.2.615

What's Changed

Exciting New Features ✨

• feat: support sample for table scan by @xudong963 in #16216
• feat(meta): Support create dictionary meta api by @Winnie-Hong0927 in #16178
• feat: auth by refresh and session tokens. by @youngsofun in #16220
• feat: http handler support set variable. by @youngsofun in #16239
• feat(query): support json_object_agg function by @b41sh in #16238
• feat: support block level table sample by @xudong963 in #16237
• feat(query): add identifier function from session variable by @sundy-li in #16264

Thoughtful Bug Fix 🔧

• fix(query): cume_dist() always return unbounded frame by @TCeason in #16242
• fix(query): fix alter user set MUST_CHANGE_PASSWORD by @b41sh in #16243

Code Refactor 🎉

• refactor(query): remove cache solt by @zhang2014 in #16233
• refactor: optimize share table performance by @lichuang in #16218
• refactor(query): don't retry transform on each block by @sundy-li in #16235
• refactor(metactl): change to subcommands & support transfer-leader by @everpcpc in #16254
• refactor(deps): Bump OpenDAL and other crates by @Xuanwo in #16251
• refactor(query): remove named cache by @zhang2014 in #16245
• refactor(query): decrease information_schema.tables call union by @TCeason in #16246
• refactor: introduce new method accurate_columns_ranges to Table by @dantengsky in #16247

Others 📒

• chore: remove admin api for testing for old version SM by @drmingdrmer in #16236
• chore: disable table info refreshing for ai_to_sql by @dantengsky in #16240
• chore: impl Display for LicenseInfo and JWTClaims<T> by @drmingdrmer in #16244
• chore: update command for metactl in tests by @everpcpc in #16263
• chore: more logs for attached table refreshing by @dantengsky in #16261
• chore: refactoring some functions by @b41sh in #16265
• chore: comment out fake_time test by @dantengsky in #16269
• chore(query): revert #16192 by @Dousir9 in #16271

Full Changelog: v1.2.609...v1.2.615

v1.2.615-nightly

What's Changed

Others 📒

• chore(query): revert #16192 by @Dousir9 in #16271

Full Changelog: v1.2.614-nightly...v1.2.615-nightly

v1.2.614-nightly

What's Changed

Exciting New Features ✨

• feat(query): add identifier function from session variable by @sundy-li in #16264

Others 📒

• chore: comment out fake_time test by @dantengsky in #16269

Full Changelog: v1.2.613-nightly...v1.2.614-nightly

v1.2.613-nightly

What's Changed

Exciting New Features ✨

• feat: support block level table sample by @xudong963 in #16237

Thoughtful Bug Fix 🔧

• fix(query): fix alter user set MUST_CHANGE_PASSWORD by @b41sh in #16243

Code Refactor 🎉

• refactor(query): remove named cache by @zhang2014 in #16245
• refactor(query): decrease information_schema.tables call union by @TCeason in #16246
• refactor: introduce new method accurate_columns_ranges to Table by @dantengsky in #16247

Others 📒

• chore: update command for metactl in tests by @everpcpc in #16263
• chore: more logs for attached table refreshing by @dantengsky in #16261
• chore: refactoring some functions by @b41sh in #16265

Full Changelog: v1.2.612-nightly...v1.2.613-nightly

v1.2.612-nightly

What's Changed

Code Refactor 🎉

• refactor(metactl): change to subcommands & support transfer-leader by @everpcpc in #16254
• refactor(deps): Bump OpenDAL and other crates by @Xuanwo in #16251

Full Changelog: v1.2.611-nightly...v1.2.612-nightly

v1.2.611-nightly

What's Changed

Exciting New Features ✨

• feat: auth by refresh and session tokens. by @youngsofun in #16220
• feat: http handler support set variable. by @youngsofun in #16239
• feat(query): support json_object_agg function by @b41sh in #16238

Thoughtful Bug Fix 🔧

• fix(query): cume_dist() always return unbounded frame by @TCeason in #16242

Code Refactor 🎉

• refactor(query): don't retry transform on each block by @sundy-li in #16235

Others 📒

• chore: disable table info refreshing for ai_to_sql by @dantengsky in #16240
• chore: impl Display for LicenseInfo and JWTClaims<T> by @drmingdrmer in #16244

Full Changelog: v1.2.610-nightly...v1.2.611-nightly

v1.2.610-nightly

What's Changed

Exciting New Features ✨

• feat: support sample for table scan by @xudong963 in #16216
• feat(meta): Support create dictionary meta api by @Winnie-Hong0927 in #16178

Code Refactor 🎉

• refactor(query): remove cache solt by @zhang2014 in #16233
• refactor: optimize share table performance by @lichuang in #16218

Others 📒

• chore: remove admin api for testing for old version SM by @drmingdrmer in #16236

Full Changelog: v1.2.609-nightly...v1.2.610-nightly

v1.2.609

What's Changed

Exciting New Features ✨

• feat: support recursive cte used in multiple places by @xudong963 in #15835
• feat(query): support distinct from for hash join by @Dousir9 in #15838
• feat: Implement Default for CatalogInfo by @Xuanwo in #15844
• feat(query): enable udf in udf call by @sundy-li in #15839
• feat(query): support row fetch for merge into by @Dousir9 in #15859
• feat: support filling uuid when loading data and uuid is missing/empty in some rows. by @youngsofun in #15871
• feat: stream consuming for copy into LOCATION from stmt by @dantengsky in #15882
• feat: publish databend-common-ast to crates.io by @andylokandy in #15905
• feat: Persist Meta-Service State Machine on Disk by @drmingdrmer in #15772
• feat: failsafe tool fuse_amend by @dantengsky in #15929
• feat: refactor create share endpoint ddl by @lichuang in #15937
• feat: add built-in udfs in config by @BohuTANG in #15938
• feat(planner): support pruning columns for merge into when insert only by @Dousir9 in #15948
• feat: clickhouse handler no longer support insert with format. by @youngsofun in #15952
• feat(query): Array lambda function support outer scope columns by @b41sh in #15957
• feat: support real-time retrieval of profiles from admin API (part 1) by @dqhl76 in #15958
• feat: refactor create database from share ddl by @lichuang in #15950
• feat: pretty print backtrace by @andylokandy in #15913
• feat: allow tuple field name to contain '_'. by @youngsofun in #15965
• feat(query): alter user support modify current password by @TCeason in #15962
• feat: update sort algorithm using loser tree for multi sort merge by @forsaken628 in #15869
• feat: orc support missing fields. by @youngsofun in #15970
• feat: orc add option missing_field_as. by @youngsofun in #15974
• feat(executor): support error profiling for cluster mode by @zhang2014 in #15969
• feat(query): implement HAVERSINE by @kkk25641463 in #15971
• feat(query): implement st_length/st_distance by @kkk25641463 in #15982
• feat: config option for syncing disk cache data by @dantengsky in #15984
• feat: add tenant&queryid to udf client by @BohuTANG in #15987
• feat: Reducing column.clone overhead in transform aggregate by introducing InputColumns by @forsaken628 in #15991
• feat: support real-time retrieval of profiles from admin API (part 2) by @dqhl76 in #15975
• feat: parquet add option missing_field_as. by @youngsofun in #15993
• feat: http handler limit body size of each response to 10MB. by @youngsofun in #15960
• feat: add NameResolutionSuggest to enhancement table name case sensitive error by @forsaken628 in #15889
• feat: refactor share spec location and format by @lichuang in #15989
• feat(query): add setting sort_spilling_batch_bytes by @sundy-li in #16019
• feat: change nan/inf to NaN/Infinity in http handler results. by @youngsofun in #16017
• feat: pretty print backtrace on panic by @andylokandy in #16024
• feat(ast): add TokenKind::{Get, Put} by @andylokandy in #16020
• feat(query): add new setting enable_dst_hour_fix by @TCeason in #16022
• feat: Change 'inf' to 'Infinity' when unloading CSV/TSV by @youngsofun in #16028
• feat(query): ST_CONTAINS by @kkk25641463 in #15994
• refactor: Refactor aggregate hashtable, replace &[Column] with InputColumns by @forsaken628 in #16038
• feat(query): ST_SETSRID/ST_NPOINTS by @kkk25641463 in #16035
• feat: new table function set_cache_capacity by @dantengsky in #16016
• feat: support must change password option for create user by @b41sh in #16031
• feat: snapshots generated in multi txn has same prev_snapshot_id by @SkyFan2002 in #16044
• feat(query): add option [ IGNORE | RESPECT NULLS ] functionality for window rank function(first_value, last_value, nth_value) by @TCeason in #15919
• feat: add function name to udf client header by @everpcpc in #16053
• feat: back compatibility of old share db by @lichuang in #16056
• feat: log file with local time by @everpcpc in #16064
• feat: add share integration test by @lichuang in #16051
• feat(query): impl LocalShuffle by @Freejww in #16055
• feat(query): add setting enable_strict_datetime_parser by @TCeason in #16067
• feat: improve selectivity accuracy by @xudong963 in #16069
• feat: optimize loser tree, disable peek top2 by @forsaken628 in #15979
• feat(storage): add table function clustering_statistics by @zhyass in #16081
• feat: limit auto cast when loading from column store. by @youngsofun in #16082
• feat(query): PartitionsShuffleKind::ConsistentHash support by @forsaken628 in #16094
• feat(http): expose queries queue length to /v1/status by @flaneur2020 in #16112
• feat(storage): refactor recluster by @zhyass in #16070
• feat(query): support json null for nullable response by @everpcpc in #16120
• feat(query): hash partitioning in window by @Freejww in #16090
• feat: generate accurate histogram by @xudong963 in #16018
• feat(query): add sql variable support by @sundy-li in #16134
• feat(query): support parse create dictionary stmt by @Winnie-Hong0927 in #16137
• feat(storage): refactor compact by @zhyass in #16119
• feat: add histogram info to fuse_statistic table by @xudong963 in #16141
• feat(query): add user function admin api by @zhang2014 in #16146
• feat: add is_attach column to system.tables and disable index creation for attache tables by @dantengsky in #16166
• feat(planner): unify execution of DML statements (MERGE, UPDATE, DELETE) by @Dousir9 in #16060
• feat(query): Support json_array_agg function by @b41sh in #16169
• feat: add share catalog by @lichuang in #16172
• feat: explain analyze output partial infos to debug cardinality estimator by @xudong963 in #16185
• feat: transfer leader command for meta-service by @drmingdrmer in #16198
• feat: meta-service transfer_leader: add response and default value by @drmingdrmer in #16201
• feat: allow casting int to uint for string functions by @andylokandy in #16210
• feat(query): Support materialized view match algorithm by @b41sh in #16023
• feat: grant view to share by @lichuang in #16186
• feat(query): ST_TRANSFORM by @kkk25641463 in #15992
• feat: introduce new setting enable_last_snapshot_location_hint by @dantengsky in #16226

Thoughtful Bug ...

v1.2.609-nightly

What's Changed

Thoughtful Bug Fix 🔧

• fix: block_entry.memory_size by @forsaken628 in #16230

Others 📒

• chore(planner): fix distributed merge into by @Dousir9 in #16228

Full Changelog: v1.2.608-nightly...v1.2.609-nightly

v1.2.608-nightly

What's Changed

Code Refactor 🎉

• refactor: CrudMgr::update should return only when the value is changed by @drmingdrmer in #16225

Others 📒

• chore: refine meta-service by @drmingdrmer in #16229

Full Changelog: v1.2.607-nightly...v1.2.608-nightly