This Week in Databend #138

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 Multi-Table Insert

Databend now supports multi-table inserts, allowing data to be inserted into multiple different tables according to actual needs. This includes support for both unconditional and conditional insert modes.

-- Unconditional multi-table insert
INSERT [ OVERWRITE ] ALL
  intoClause [ ... ]
<subquery>

-- Conditional multi-table insert
INSERT [ OVERWRITE ] { FIRST | ALL }
  { WHEN <condition> THEN intoClause [ ... ] }
  [ ... ]
  [ ELSE intoClause ]
<subquery>

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

• PR | feat: support multi-table insert

Code Corner

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

Adding Support for OpenTelemetry Context Propagation

OpenTelemetry is a tool for observing performance, helping to track and monitor data requests in distributed systems. Databend Query now has built-in support for OpenTelemetry context propagation, enabling better integration into existing monitoring systems and facilitating developers to track and analyze the flow of queries throughout the system.

If you're interested, please read the materials below to learn how to implement distributed tracing with the Databend Go Driver.

• Examples | How to Realize Distributed Tracing Using Native Go Driver with Databend
• PR | feat: support otel context propagation for databend-query

Highlights

We have also made these improvements to Databend that we hope you will find helpful:

• Added support for GEO functions

  st_makeline
  
  and

  st_geometryfromewkb
  
  .
• Added support for refreshing inverted indexes after data changes, including synchronous and asynchronous modes.
• Added time travel and specifying offsets for

  STREAM
  
  .
• Read the documentation Docs | Access Control to understand access control in Databend.

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.

Adding Support for Query Forwarding

Databend plans to support query forwarding, mainly for the following two benefits:

• Flexible Routing: Avoids the necessity to route queries strictly to their origin node.
• Statelessness: Similar to k8s deployments, the system doesn't require stateful management.

Issue #15127 | feat: query forward

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.

New Contributors

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

• @kkk25641463 implemented support for the

  st_makeline
  
  function, #15059.
• @c8ef fixed a type mismatch issue in SQL logic tests, #15090.

Changelog

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

Full Changelog: https://github.com/datafuselabs/databend/compare/v1.2.386-nightly...v1.2.397-nightly