This Week in Databend #92

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.

• PR #11272 | feat: support alias in where clause

databend-metactl

Is Included in the Databend Release

databend-metactl

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.

• Docs | Back Up and Restore Databend Meta Service Cluster

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

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

git fetch https://github.com/databendlabs/databend.git --tags

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/databendlabs/databend/compare/v1.1.23-nightly...v1.1.30-nightly