---
title: 'This Week in Databend #141'
date: 2024-04-22
slug: category-weekly/2024-04-22-databend-weekly
cover_url: 'weekly/weekly-141.jpg'
image: 'weekly/weekly-141.jpg'
tags: [weekly]
category: Weekly
description: 'Stay up to date with the latest weekly developments on Databend!'
contributors:
  - name: andylokandy
  - name: b41sh
  - name: BohuTANG
  - name: Chasen-Zhang
  - name: dantengsky
  - name: Dousir9
  - name: dqhl76
  - name: drmingdrmer
  - name: finchxx
  - name: lichuang
  - name: soyeric128
  - name: sundy-li
  - name: TCeason
  - name: xudong963
  - name: YichiZhang0613
  - name: youngsofun
  - name: zhyass
authors:
  - PsiACE
---

[Databend](https://github.com/databendlabs/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](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.

{/* truncate */}

- `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](https://databend.com/contact-us/) or refer to the resources listed below:

- [PR #15196 | feat(query): match function support multiple fields with boost](https://github.com/databendlabs/databend/pull/15196)

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

<img data-zoom src="https://docs.databend.com/img/deploy/deploy-cluster-arch.png" className="databendBlogSquareImg"/>

- [Docs | Docker & Local Deployments](https://docs.databend.com/guides/deploy/deploy/non-production/deploying-local)
- [Docs | Deploying Databend Cluster](https://docs.databend.com/guides/deploy/deploy/production/metasrv-deploy)

## 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` object and the `nextval` function are used to retrieve and increment a sequence.

We can use MetaSrv's built-in sequence feature. When we call `nextval`, it updates the metadata for `seq1` and returns a unique number from MetaSrv for each object. Although the sequence may not be contiguous, it always auto-increments.

```sql
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](https://github.com/databendlabs/databend/issues/15180)

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](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](https://github.com/finchxx) updated sqllogictest to 0.19.1, [#15242](https://github.com/databendlabs/databend/pull/15242).
- [@YichiZhang0613](https://github.com/YichiZhang0613) fixed inconsistent comments in the code, [#15229](https://github.com/databendlabs/databend/pull/15229).

## Changelog

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

**Full Changelog**: [https://github.com/databendlabs/databend/compare/v1.2.420-nightly...v1.2.428-nightly](https://github.com/databendlabs/databend/compare/v1.2.420-nightly...v1.2.428-nightly)