What's Changed

Exciting New Features ✨

• feat: Copy into support optimize hint by @jun0315 in #11614
• feat(query): Support generate virtual columns by @b41sh in #11590
• feat(query): insert/mutation/update deduplicate based on label by @jun0315 in #11610
• feat: support distributed Top-N. by @RinChanNOWWW in #11662
• feat(query): Allow root user alter password by @b41sh in #11671
• feat(query): enable default lazy_topn_threshold setting to 1000 by @sundy-li in #11677
• feat: Bump OpenDAL to 0.37.0 by @Xuanwo in #11683
• feat(meta): add seq to ExpireValue by @drmingdrmer in #11686
• feat: support column position like $N. by @youngsofun in #11672

Thoughtful Bug Fix 🔧

• fix(front): search styles by @Chasen-Zhang in #11640
• fix: cached items should be kept being evict, till enough room be made for the new item. by @lichuang in #11620
• fix: iejoin hang by @xudong963 in #11642
• fix: fix hash join hang by @xudong963 in #11654
• fix(query): fix parse json with escaped and UTF-8 characters by @b41sh in #11657
• fix(storage/s3): Add allow_anonymous support for storage by @Xuanwo in #11661
• fix(query): json cast to string as escaped string by @b41sh in #11665
• fix(query): incorrect block index for lazy topn by @zhang2014 in #11692
• fix(query): Fix json special and foreign characters display errors by @b41sh in #11698

Code Refactor 🎉

• refactor: switch table meta encoding scheme to msgpack by @dantengsky in #11592
• refactor(storage): unify commit path of table mutation and append by @zhyass in #11626
• refactor: add number of segment and block to common_meta_app::schema::TableStatistics by @dantengsky in #11476
• refactor: improve single pipeline merge sort for Top-N. by @RinChanNOWWW in #11681

Build/Testing/CI Infra Changes 🔌

• ci: run sqllogic ydb with 8c16g by @everpcpc in #11637
• ci: run production ci on self-hosted by @everpcpc in #11639
• ci: fix artifacts for release build by @everpcpc in #11643
• ci: fix syntax error in production ci by @everpcpc in #11644
• ci: fix build profile for test script metactl restore by @everpcpc in #11646
• ci: fix test condition for ee by @everpcpc in #11647
• ci: enable sccache for macos build by @everpcpc in #11648

Documentation 📔

• docs: deploy cluster by @soyeric128 in #11631
• docs: fix typos in 30-license-faqs.md by @tisonkun in #11638
• docs(blog): add tableau by @PsiACE in #11652
• docs(catalog): correct information_schema is supported by @tisonkun in #11658
• docs: load-unload-overview illustration by @soyeric128 in #11664
• docs(blog): add this week in databend 96 by @PsiACE in #11663
• docs: max_files option by @soyeric128 in #11670
• docs: Deploy mode updates by @soyeric128 in #11668
• docs: sql alias by @soyeric128 in #11673
• docs: docker deploy updates by @soyeric128 in #11676
• docs: column alias updates by @soyeric128 in #11680
• docs: set var updates by @soyeric128 in #11690
• docs: updated atomic tip by @soyeric128 in #11691
• docs: system.indexes by @soyeric128 in #11694
• docs: updated description for lazy_topn_threshold by @soyeric128 in #11695

Others 📒

• chore: remove take_string_types by @Dousir9 in #11645
• chore: add tpcds q64 by @Dousir9 in #11655
• chore: contributor-friendly error message by @JackTan25 in #11660
• chore: Rewrite IGNORE_TEXT by @Chasen-Zhang in #11667
• chore: disable non_equi_conditions in eager aggregation by @Dousir9 in #11679
• chore(storage): adjust the file dirs by @zhyass in #11687
• chore(deps): bump xml-rs from 0.8.4 to 0.8.14 by @dependabot in #11674
• chore(expr): check type of BlockEntry by @andylokandy in #11684
• chore(planner): shrink constant type by @andylokandy in #11688
• chore(storage): remove compact in recluster by @zhyass in #11697

Full Changelog: https://github.com/datafuselabs/databend/compare/v1.1.54-nightly...v1.1.56-draft