v1.0.32-nightly

What's Changed

Exciting New Features ✨

• feat: basic impl for FlightSQL handler. by @youngsofun in #10732

Thoughtful Bug Fix 🔧

• fix: fix duplicate processor. by @RinChanNOWWW in #10734

Code Refactor 🎉

• refactor(expr): merge SrfExpr into Expr by @andylokandy in #10739

Documentation 📔

• docs: Metabase by @soyeric128 in #10752

Others 📒

• chore(ci): build release on larger runner by @everpcpc in #10753
• chore(test): revert repeat 3 time for each pr by @zhang2014 in #10755
• chore(ci): download binaries before setup docker by @everpcpc in #10756

Full Changelog: v1.0.31-nightly...v1.0.32-nightly

v1.0.31-nightly

What's Changed

Exciting New Features ✨

• feat(query): support show columns query by @TCeason in #10726
• feat: PIVOT result column by @SkyFan2002 in #10733

Documentation 📔

• docs: fix concat and concat_ws by @soyeric128 in #10744

Others 📒

• chore(ci): run release in self-hosted runner by @everpcpc in #10736
• chore(query): add compare domain for string types by @sundy-li in #10740

Full Changelog: v1.0.30-nightly...v1.0.31-nightly

v1.0.30-nightly

What's Changed

Documentation 📔

• docs(monitor): add prometheus and grafana by @PsiACE in #10701

Others 📒

• chore: add some annotations for bugfix by @xudong963 in #10730
• chore(query): add with_capacity_hint methods in ColumnBuilder by @sundy-li in #10731

Full Changelog: v1.0.29-nightly...v1.0.30-nightly

v1.0.29

What's Changed

Documentation 📔

• docs: openai-api-key by @soyeric128 in #10717

Others 📒

• chore(query): make flush returns empty builder by @sundy-li in #10715
• chore(cluster): close flight receiver in event by @zhang2014 in #10718

Full Changelog: v1.0.28-nightly...v1.0.29-nightly

v1.0.28-nightly

What's Changed

Exciting New Features ✨

• feat(query): list_stage table function. by @xinlifoobar in #10658
• feat(function): implement pivot and unpivot by @SkyFan2002 in #10676
• feat(explain): add a simple explain join to display the join orders by @sundy-li in #10704
• feat(function): Add list Aggregate function by @b41sh in #10708

Thoughtful Bug Fix 🔧

• fix(exclude): column name case issue by @SkyFan2002 in #10656
• fix: do not build pipeline before checking cache. by @RinChanNOWWW in #10699
• fix: manual drop state to prevent memory leak by @ariesdevil in #10706
• fix(test): add order by for pivot test by @SkyFan2002 in #10707
• fix: fix Nullable(Decimal) division. by @RinChanNOWWW in #10693
• fix: left join oom by @xudong963 in #10711

Code Refactor 🎉

• refactor(copy): calc suitable parallelism for reading parquet splits. by @youngsofun in #10695
• refactor(cluster): rename new_flight to flight by @zhang2014 in #10702
• refactor: shrink bloom index meta cache size by @dantengsky in #10692
• refactor(planner): Refine lowering procedure for ScalarExpr by @leiysky in #10710
• refactor(expr): remove Literal by @andylokandy in #10712

Build/Testing/CI Infra Changes 🔌

• ci(query): add more test for grant privileges by @TCeason in #10705

Documentation 📔

• docs(query): delete doc about async_insert by @TCeason in #10703
• docs: added blog cover by @soyeric128 in #10714

New Contributors

• @SkyFan2002 made their first contribution in #10656

Full Changelog: v1.0.27-nightly...v1.0.28-nightly

v1.0.27-nightly

What's Changed

Exciting New Features ✨

• feat: Access shared table meta accross open sharding service by @lichuang in #10690

Thoughtful Bug Fix 🔧

• fix(query): fix missing notify for TransformHashJoinProbe by @zhang2014 in #10694
• fix(query): fix view select filter can not push down to scan by @b41sh in #10675

Code Refactor 🎉

• refactor(planner): Refactor set returning function by @leiysky in #10683

Documentation 📔

• docs: blog for ai2sql by @soyeric128 in #10681

Others 📒

• chore(ci): remove tag pr & release for benchmark by @everpcpc in #10686

Full Changelog: v1.0.26-nightly...v1.0.27-nightly

v1.0.26-nightly

What's Changed

Thoughtful Bug Fix 🔧

• fix(functions): fix multiple SUM_IF functions return incorrect results by @b41sh in #10680
• fix(query): create view check unknown table by @TCeason in #10670

Code Refactor 🎉

• refactor(cluster): using pull mode for cluster mode again by @zhang2014 in #10664

Documentation 📔

• docs: ai2sql updates by @soyeric128 in #10679
• docs: note to linux packages by @soyeric128 in #10682
• docs(aggregate): add index for the aggregate functions by @BohuTANG in #10684

Full Changelog: v1.0.25-nightly...v1.0.26-nightly

v1.0.25-nightly

What's Changed

Exciting New Features ✨

• feat(front): Support for enlarging images in articles by @Chasen-Zhang in #10672
• feat(openai): add openai_api_key to config by @BohuTANG in #10674

Thoughtful Bug Fix 🔧

• fix(text): remove "LTS" and release tag by @Chasen-Zhang in #10657
• fix(text): History versions description by @Chasen-Zhang in #10659
• fix: support positions in grouping sets. by @RinChanNOWWW in #10660
• fix(query): warn about reserved built-in user by @everpcpc in #10666
• fix: in copy force mode, files should be insert unconditionally by @dantengsky in #10671

Code Refactor 🎉

• refactor: AST check is not needed after static runtime check added by @Xuanwo in #10655
• refactor: atomic table commit and upsert_copied_files_info_to_meta by @dantengsky in #10427

Others 📒

• chore(planner): support multi filter pushdown into scan by @sundy-li in #10662
• chore(system): add disable_system_table_load to allow disable load some system tables by @BohuTANG in #10665

Full Changelog: v1.0.24-nightly...v1.0.25-nightly

v1.0.24-nightly

What's Changed

Exciting New Features ✨

• feat(front): Add [fetch-databend-releases] plugin and refactor download page by @Chasen-Zhang in #10640
• feat(aggregate function): quantile_cont supports multiple levels by @ariesdevil in #10633

Thoughtful Bug Fix 🔧

• fix(replaced): x86_64-unknown-linux-musl => x86_64-unknown-linux-gnu by @Chasen-Zhang in #10648
• fix: avoid dependency loop when selecting from view. by @RinChanNOWWW in #10650

Documentation 📔

• docs(ai): refine the layout of openai functions by @BohuTANG in #10643
• docs(weekly): add this week in databend 85 by @PsiACE in #10627
• docs(group by): add group by query syntax by @BohuTANG in #10652

Others 📒

• chore(query): Reopen keep-alive for MySQL & rollback socket2 to 0.4 by @yufan022 in #10642
• chore(openai): add openai.rs to prepare more AI functions by @BohuTANG in #10645
• chore(async-openai): Come back to upstream by @Xuanwo in #10649
• chore(query): make copy into table support auto cast schema by @sundy-li in #10630

Full Changelog: v1.0.23-nightly...v1.0.24-nightly

v1.0.23-nightly

What's Changed

Exciting New Features ✨

• feat(query): enable runtime cast transform in loading parquet files by @sundy-li in #10621
• feat(storage): Support domain for nested data types by @b41sh in #10548
• feat: support CUBE and ROLLUP. by @RinChanNOWWW in #10601
• feat(planner): pretty display more errors with span by @andylokandy in #10612
• feat(query): system.columns filter view engine fields by @TCeason in #10626
• feat: add ai_to_sql transalte natual lanauge to SQL based on your table schema by @BohuTANG in #10637

Code Refactor 🎉

• refactor(planner): remove required_type in TypeChecker by @andylokandy in #10636

Documentation 📔

• docs(query): add query syntax index by @BohuTANG in #10629
• docs(query): refine the with syntax by @BohuTANG in #10631
• docs: add docs for grouping sets. by @RinChanNOWWW in #10638

Others 📒

• chore(query): do not write duplicate query log by @everpcpc in #10628

Full Changelog: v1.0.22-nightly...v1.0.23-nightly