This Week in Databend #135

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 .

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

For example,

max_running_queries=3

If you would like to learn more, please contact the Databend team or refer to the resources listed below:

• PR #14878 | feat(query): support queries queue

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

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;
            }
$$

Support for Python UDF Scripts is actively progressing.

• PR #14799 | feat(query): introduce arrow-udf-js

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_<type>
  
  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.

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

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 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