This Week in Databend #141

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.

Enhancing Full-Text Search

Databend has enhanced the full-text search capabilities by extending and optimizing the match and query functions. This allows users to perform precise searches and retrieve data based on complex requirements.

• match
  
  function support multiple fields with boost and only support query text without syntax

• query
  
  function support search with query syntax:
  1. simple terms, like

     title:quick
     
  2. bool operator terms, like

     title:fox AND dog OR cat
     
  3. must and negative operator terms, like

     title:+fox -cat
     
  4. phrase terms, like

     title:"quick brown fox"
     
  5. multiple field with boost terms, like

     title:fox^5 content:dog^2
     

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

• PR #15196 | feat(query): match function support multiple fields with boost

Code Corner

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

Updating Deployment Documentation

The documentation for deploying Databend has been recently updated. Feel free to read and learn about Docker and the cluster deployment process in detail.

• Docs | Docker & Local Deployments
• Docs | Deploying Databend Cluster

Highlights

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

• Added support for using CTEs in update and insert statements.
• Made

  create table as select
  
  atomic.

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 SEQUENCE

The

SEQUENCE

nextval

We can use MetaSrv's built-in sequence feature. When we call

nextval

seq1

CREATE OR REPLACE SEQUENCE seq1;
create table t1(a bigint, b string);
insert into t1 values(nextval(seq1), 'b');

SELECT nextval(seq1);
---------
     102

Issue #15180 | feat: CREATE OR REPLACE SEQUENCE

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.

• @finchxx updated sqllogictest to 0.19.1, #15242.
• @YichiZhang0613 fixed inconsistent comments in the code, #15229.

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.420-nightly...v1.2.428-nightly