--- title: 'This Week in Databend #135' date: 2024-03-11 slug: category-weekly/2024-03-11-databend-weekly cover_url: 'weekly/weekly-135.jpg' image: 'weekly/weekly-135.jpg' tags: [weekly] category: Weekly description: 'Stay up to date with the latest weekly developments on Databend!' contributors: - name: andylokandy - name: ariesdevil - name: b41sh - name: dantengsky - name: Dousir9 - name: drmingdrmer - name: everpcpc - name: Freejww - name: JackTan25 - name: lichuang - name: PsiACE - name: SkyFan2002 - name: soyeric128 - name: sundy-li - name: TCeason - name: xudong963 - name: youngsofun - name: zhang2014 - name: ZhiHanZ authors: - PsiACE --- [Databend](https://github.com/databendlabs/databend) is a modern cloud data warehouse, serving your massive-scale analytics needs at low cost and complexity. Open source alternative to Snowflake. Also available in the cloud: [https://app.databend.com](https://app.databend.com) . ## What's New Stay informed about the latest features of Databend. ### Supporting Query Queue Databend now supports the query queue feature, which allows you to set `max_running_queries` to determine the maximum number of concurrently running queries. If there are more queries, they will be queued until processing resources are freed up. For example, `max_running_queries=3` means that up to 3 queries can run concurrently, and any new queries will be blocked until one of the previous queries is completed. {/* truncate */} If you would like to learn more, please contact the [Databend team](https://databend.com/contact-us/) or refer to the resources listed below: - [PR #14878 | feat(query): support queries queue](https://github.com/databendlabs/databend/pull/14878) ## Code Corner Discover some fascinating code snippets or projects that showcase our work or learning journey. ### Exploring Databend's UDF Script Databend now adds UDF Script support, allowing JavaScript to be used as a UDF script. For example, you can define a `gcd` function with the following statement: ```sql CREATE FUNCTION gcd (INT, INT) RETURNS BIGINT LANGUAGE javascript HANDLER = 'gcd_js' AS $$ export function gcd_js(a, b) { while (b != 0) { let t = b; b = a % b; a = t; } return a; } $$ ``` ![udf script](../static/img/blog/udf-script.png) Support for Python UDF Scripts is actively progressing. - [PR #14799 | feat(query): introduce arrow-udf-js](https://github.com/databendlabs/databend/pull/14799) ## Highlights We have also made these improvements to Databend that we hope you will find helpful: - Added support for transactions and multi-line SQL statements in TASK. - Added statistical information for `VACUUM TABLE` results. - Added support for `is_` series of functions for the Variant type. - Added support for creating inverted indexes. ## What's Up Next We're always open to cutting-edge technologies and innovative ideas. You're more than welcome to join the community and bring them to Databend. ### Upgrading sqllogictest to the Latest Version Databend aims to upgrade sqllogictest to the latest version to obtain more comprehensive support. ```sql sqllogictest = "0.19.1" ``` This is a good first issue, aimed at guiding everyone interested in Rust and Databend to participate. [Issue #14874 | Update sqllogictest crate to the latest](https://github.com/databendlabs/databend/issues/14874) Please let us know if you're interested in contributing to this feature, or pick up a good first issue at [https://link.databend.com/i-m-feeling-lucky](https://link.databend.com/i-m-feeling-lucky) to get started. ## Changelog You can check the changelog of Databend Nightly for details about our latest developments. **Full Changelog**: [https://github.com/databendlabs/databend/compare/v1.2.359-nightly...v1.2.371-nightly](https://github.com/databendlabs/databend/compare/v1.2.359-nightly...v1.2.371-nightly)