This Week in Databend #92

PsiACEMay 7, 2023

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

What's On In Databend

Stay connected with the latest news about Databend.

Using Column Aliases in a Where Clause

A column alias provides a way to create a clean or more descriptive header for a results set.

Databend now supports column aliases in WHERE clause. Please note that if the alias and the column name are the same, the WHERE clause will recognize the alias as the column name:

> select number * 2 as number from numbers(3) where (number + 1) % 3 = 0;

│ number │
│ UInt64 │

If you are interested in learning more, please check out the resources listed below.

Is Included in the Databend Release

is a command-line tool that allows users to manage the Databend Meta Service cluster. It can be used to back up and restore the metadata.

Now, databend-metactl will be released together with Databend and no longer requires building it manually.

If you are interested in learning more, please check out the resources listed below.

Code Corner

Discover some fascinating code snippets or projects that showcase our work or learning journey.

Connection Issues with Invalid Semver Error

When compiling and running Databend, you may encounter connection issues with databend-meta and receive an error message containing

Invalid semver
. This is due to Databend's protocol compatibility check using semantic versions.

To resolve this issue, you can fetch the latest tags from the official Databend repository using the command

git fetch --tags
. This ensures that your project is using the latest version of databend-meta and passes the version check.


Here are some noteworthy items recorded here, perhaps you can find something that interests you.

  • Optimizer now supports constant folding. If interested, please check PR #11216.
  • Learn how to Transform Data During Load through three simple tutorials.
  • Added bitmap functions:

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.

Introduce Timeout Mechanism to Control the Query Optimization Time

Optimizing complex queries with numerous joins can be a time-consuming task. To avoid performing an exhaustive search of the entire query plan space, we can set a timeout for optimization.

The timeout can be based on a logical time, such as the number of applied transform rules, rather than wall time. Once the timeout is reached, a greedy search can be performed instead of generating new transform rules.

Issue #11133 | Introduce timeout mechanism to control the query optimization time

Please let us know if you're interested in contributing to this issue, or pick up a good first issue at to get started.

New Contributors

We always open arms to everyone and can't wait to see how you'll help our community grow and thrive.

  • @JackTan25 made their first contribution in #11290. The PR fixes table options validation.


You can check the changelog of Databend Nightly for details about our latest developments.

Full Changelog:

Share this post

Subscribe to our newsletter

Stay informed on feature releases, product roadmap, support, and cloud offerings!