---
title: Databend 开源周报第 77 期
description: Databend 现在提供 meta 升级程序以辅助完成从 0.8 到 0.9 升级过程中的元数据迁移工作，另外 Nigntly v1.0 发布目标也在征集中。
slug: category-weekly/databend-weekly-77
date: 2023-01-29
tags: [weekly]
category: Weekly

image: databend-weekly.png
authors:
  - DatabendLabs
---

# Databend 开源周报 第 77 期

> 英文版移步：https://www.databend.com/blog/2023-01-18-databend-weekly
>
> [Databend](https://github.com/databendlabs/databend) 是一款强大的云数仓。专为弹性和高效设计。自由且开源。即刻体验云服务：[https://app.databend.cn](https://app.databend.cn) 。

{/* truncate */}

## What's New

探索 Databend 本周新进展，遇到更贴近你心意的 Databend。

### Features & Improvements :sparkles:

**Meta**

- 使用 `expressin::TableSchema` 来替换过时的 `datavalues::DataSchema` ([#9506](https://github.com/databendlabs/databend/pull/9506))
- `iter()` 迭代每棵树和每条记录 ([#9621](https://github.com/databendlabs/databend/pull/9621))

**Expression**

- 实现其他地理函数 ([#9588](https://github.com/databendlabs/databend/pull/9588))

**Optimizer**

- 基于直方图改进 JOIN 基数估计 ([#9594](https://github.com/databendlabs/databend/pull/9594))

**Planner**

- 改进 JOIN 重排算法 ([#9571](https://github.com/databendlabs/databend/pull/9571))

**Query**

- 支持带占位符的插入 ([#9575](https://github.com/databendlabs/databend/pull/9575))
- 使用 set 设定设置时支持表达式 ([#9574](https://github.com/databendlabs/databend/pull/9574))
- 为 sharding-jdbc 支持 information_schema ([#9583](https://github.com/databendlabs/databend/pull/9583))
- 为表函数添加具名参数支持 ([#9630](https://github.com/databendlabs/databend/pull/9630))

**Storage**

- read_parquet 页索引 ([#9563](https://github.com/databendlabs/databend/pull/9563))
- 更新 interpreter 和 storage 支持 ([#9261](https://github.com/databendlabs/databend/pull/9261))

### Code Refactoring :tada:

- 优化 on_error ([#9473](https://github.com/databendlabs/databend/pull/9473))

**Meta**

- 移除无用的元数据类型和转换 ([#9584](https://github.com/databendlabs/databend/pull/9584))

**Parser**

- 为 format_options 增加更严格的解析器 ([#9635](https://github.com/databendlabs/databend/pull/9635))

**Expression**

- 重排 common_expression 和 common_function ([#9585](https://github.com/databendlabs/databend/pull/9585))

### Build/Testing/CI Infra Changes :electric_plug:

- 使用预编译的二进制文件运行 sqllogictests ([#9603](https://github.com/databendlabs/databend/pull/9603))

### Bug Fixes :wrench:

**Expression**

- 常量折叠应当反复运行直到稳定 ([#9572](https://github.com/databendlabs/databend/pull/9572))
- 修复 `check_date()` 和 `to_string(boolean)` 可能会 panic ([#9561](https://github.com/databendlabs/databend/pull/9561))

**Planner**

- 修复应用 RuleFilterPushDownJoin 时的栈溢出 ([#9645](https://github.com/databendlabs/databend/pull/9645))

**Storage**

- 修复带索引 range filter 的读统计 ([#9619](https://github.com/databendlabs/databend/pull/9619))

**Sqllogictest**

- 修复 sqllogic test 在 cluster 模式 + clickhouse handler 的情况下可能会挂起的问题 ([#9615](https://github.com/databendlabs/databend/pull/9615))

## What's On In Databend

请持续关注 Databend 的最新动态。

### 升级 Databend 集群到 v0.9

Databend Query v0.9 在元数据上引入了一些不兼容的变更，这些元数据需要以手动的方式进行迁移。

Databend 提供 `databend-meta-upgrade-09` 升级工具来完成这项工作，你可以在 [release package](https://github.com/databendlabs/databend/releases) 中找到预先构建好的二进制文件，也可以选择从源码完成构建。

**升级**

```bash
databend-meta-upgrade-09 --cmd upgrade --raft-dir "<./your/raft-dir/>"
```

**阅读下述材料以了解更多讯息**

- [PR | feat(meta/upgrade): meta data upgrade program](https://github.com/databendlabs/databend/pull/9489)
- [Doc | Upgrade Databend Query](https://docs.databend.cn/guides/deploy/upgrade/upgrade/)

### Nightly v1.0 发布目标征集中

Databend v1.0 版本发布目标正在征集中。

目前计划的发布时间是 3 月份，主要会关注以下几个核心功能点：`alter` table, `update`, 和 `group by spill`。

**阅读下述材料以了解更多讯息**

- [Release proposal: Nightly v1.0](https://github.com/databendlabs/databend/issues/9604)

## What's Up Next

我们始终对前沿技术和创新理念持开放态度，欢迎您加入社区，为 Databend 注入活力。

### 为 Sqllogictest 实现类型检查机制

除了比对结果和检验是否查询成功，支持检查每一行中的每个元素的类型是否正确。

**databend/tests/sqllogictests/src/client/mysql_client.rs**

```rust
 // Todo: add types to compare
 Ok(DBOutput::Rows {
     types,
     rows: parsed_rows,
```

[Issue 9647: Feature: Add type checker for sqllogictest](https://github.com/databendlabs/databend/issues/9647)

如果你对这个主题感兴趣，可以尝试解决其中的部分问题或者参与讨论和 PR review。或者，你可以点击 https://link.databend.com/i-m-feeling-lucky 来挑选一个随机问题，祝好运！

## Changelogs

前往查看 Databend 每日构建的变更日志，以了解开发的最新动态。

地址：https://github.com/databendlabs/databend/releases

## Contributors

非常感谢贡献者们在本周的卓越工作。

| [<img alt="andylokandy" src="https://avatars.githubusercontent.com/u/9637710?v=4&s=117" width="117" />](https://github.com/andylokandy) | [<img alt="ariesdevil" src="https://avatars.githubusercontent.com/u/7812909?v=4&s=117" width="117" />](https://github.com/ariesdevil) | [<img alt="b41sh" src="https://avatars.githubusercontent.com/u/1070352?v=4&s=117" width="117" />](https://github.com/b41sh) | [<img alt="BohuTANG" src="https://avatars.githubusercontent.com/u/172204?v=4&s=117" width="117" />](https://github.com/BohuTANG) | [<img alt="dantengsky" src="https://avatars.githubusercontent.com/u/22081156?v=4&s=117" width="117" />](https://github.com/dantengsky) | [<img alt="drmingdrmer" src="https://avatars.githubusercontent.com/u/44069?v=4&s=117" width="117" />](https://github.com/drmingdrmer) |
| :-------------------------------------------------------------------------------------------------------------------------------------: | :-----------------------------------------------------------------------------------------------------------------------------------: | :-------------------------------------------------------------------------------------------------------------------------: | :------------------------------------------------------------------------------------------------------------------------------: | :------------------------------------------------------------------------------------------------------------------------------------: | :-----------------------------------------------------------------------------------------------------------------------------------: |
|                                              [andylokandy](https://github.com/andylokandy)                                              |                                              [ariesdevil](https://github.com/ariesdevil)                                              |                                              [b41sh](https://github.com/b41sh)                                              |                                             [BohuTANG](https://github.com/BohuTANG)                                              |                                              [dantengsky](https://github.com/dantengsky)                                               |                                             [drmingdrmer](https://github.com/drmingdrmer)                                             |

| [<img alt="everpcpc" src="https://avatars.githubusercontent.com/u/1808802?v=4&s=117" width="117" />](https://github.com/everpcpc) | [<img alt="leiysky" src="https://avatars.githubusercontent.com/u/22445410?v=4&s=117" width="117" />](https://github.com/leiysky) | [<img alt="mergify[bot]" src="https://avatars.githubusercontent.com/in/10562?v=4&s=117" width="117" />](https://github.com/apps/mergify) | [<img alt="PsiACE" src="https://avatars.githubusercontent.com/u/36896360?v=4&s=117" width="117" />](https://github.com/PsiACE) | [<img alt="RinChanNOWWW" src="https://avatars.githubusercontent.com/u/33975039?v=4&s=117" width="117" />](https://github.com/RinChanNOWWW) | [<img alt="soyeric128" src="https://avatars.githubusercontent.com/u/106025534?v=4&s=117" width="117" />](https://github.com/soyeric128) |
| :-------------------------------------------------------------------------------------------------------------------------------: | :------------------------------------------------------------------------------------------------------------------------------: | :--------------------------------------------------------------------------------------------------------------------------------------: | :----------------------------------------------------------------------------------------------------------------------------: | :----------------------------------------------------------------------------------------------------------------------------------------: | :-------------------------------------------------------------------------------------------------------------------------------------: |
|                                              [everpcpc](https://github.com/everpcpc)                                              |                                              [leiysky](https://github.com/leiysky)                                               |                                             [mergify[bot]](https://github.com/apps/mergify)                                              |                                              [PsiACE](https://github.com/PsiACE)                                               |                                              [RinChanNOWWW](https://github.com/RinChanNOWWW)                                               |                                               [soyeric128](https://github.com/soyeric128)                                               |

| [<img alt="sundy-li" src="https://avatars.githubusercontent.com/u/3325189?v=4&s=117" width="117" />](https://github.com/sundy-li) | [<img alt="TCeason" src="https://avatars.githubusercontent.com/u/33082201?v=4&s=117" width="117" />](https://github.com/TCeason) | [<img alt="Xuanwo" src="https://avatars.githubusercontent.com/u/5351546?v=4&s=117" width="117" />](https://github.com/Xuanwo) | [<img alt="xudong963" src="https://avatars.githubusercontent.com/u/41979257?v=4&s=117" width="117" />](https://github.com/xudong963) | [<img alt="youngsofun" src="https://avatars.githubusercontent.com/u/5782159?v=4&s=117" width="117" />](https://github.com/youngsofun) | [<img alt="yufan022" src="https://avatars.githubusercontent.com/u/30121694?v=4&s=117" width="117" />](https://github.com/yufan022) |
| :-------------------------------------------------------------------------------------------------------------------------------: | :------------------------------------------------------------------------------------------------------------------------------: | :---------------------------------------------------------------------------------------------------------------------------: | :----------------------------------------------------------------------------------------------------------------------------------: | :-----------------------------------------------------------------------------------------------------------------------------------: | :--------------------------------------------------------------------------------------------------------------------------------: |
|                                              [sundy-li](https://github.com/sundy-li)                                              |                                              [TCeason](https://github.com/TCeason)                                               |                                              [Xuanwo](https://github.com/Xuanwo)                                              |                                              [xudong963](https://github.com/xudong963)                                               |                                              [youngsofun](https://github.com/youngsofun)                                              |                                              [yufan022](https://github.com/yufan022)                                               |

| [<img alt="zhang2014" src="https://avatars.githubusercontent.com/u/8087042?v=4&s=117" width="117" />](https://github.com/zhang2014) | [<img alt="zhyass" src="https://avatars.githubusercontent.com/u/34016424?v=4&s=117" width="117" />](https://github.com/zhyass) |
| :---------------------------------------------------------------------------------------------------------------------------------: | :----------------------------------------------------------------------------------------------------------------------------: |
|                                              [zhang2014](https://github.com/zhang2014)                                              |                                              [zhyass](https://github.com/zhyass)                                               |

## Connect With Us

Databend 是一款开源、弹性、低成本，基于对象存储也可以做实时分析的新式数仓。期待您的关注，一起探索云原生数仓解决方案，打造新一代开源 Data Cloud。

- [Databend Website](https://docs.databend.cn)
- [GitHub Discussions](https://github.com/databendlabs/databend/discussions)
- [Twitter](https://twitter.com/Datafuse_Labs)
- [Slack Channel](https://link.databend.com/join-slack)