Blog

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: https://app.databend.com .

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 │
├────────┤
4
└────────┘

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

databend-metactl
Is Included in the Databend Release

databend-metactl
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.

Troubleshooting
databend-meta
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 https://github.com/datafuselabs/databend.git --tags
. This ensures that your project is using the latest version of databend-meta and passes the version check.

Highlights

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:
    bitmap_count
    and
    build_bitmap
    .

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 https://link.databend.com/i-m-feeling-lucky 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.

Changelog

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

Full Changelog: https://github.com/datafuselabs/databend/compare/v1.1.23-nightly...v1.1.30-nightly

Share this post

Subscribe to our newsletter

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