Blog

This Week in Databend #76

PsiACEJan 11, 2023

Databend is a powerful cloud data warehouse. Built for elasticity and efficiency. Free and open. Also available in the cloud: https://app.databend.com .

What's New

Check out what we've done this week to make Databend even better for you.

Features & Improvements ✨

Meta

add reader-min-msg-ver and msg-min-reader-ver in proto-conv (#9535)

Planner

support
```
tuple.1
```
and
```
get(1)(tuple)
```
(#9493)
support display estimated rows in
```
EXPLAIN
```
(#9528)

Query

efficiently memory two level group by in standalone mode (#9504)

Storage

support nested type in
```
read_parquet
```
(#9486)
add build options table (#9502)

Code Refactoring 🎉

merge new expression (#9411)
remove and rename crates (#9481)
bump rust version (#9540)

Expression

move negative functions to binder (#9484)
use error_to_null() to eval try_cast (#9545)

Functions

replace h3ron to h3o (#9553)

Format

extract
```
AligningStateTextBased
```
(#9472)
richer error context (#9534)

Query

use ctx to store the function evaluation error (#9501)
refactor map access to support view read tuple inner (#9516)

Storage

bump opendal for streaming read support (#9503)
refactor bloom index to use vectorized siphash function (#9542)

Bug Fixes 🔧

HashTable

fix memory leak for unsized hash table (#9551)

Storage

fix row group stats collection (#9537)

What's On In Databend

Stay connected with the latest news about Databend.

New Year, New Expression!

We're so thrilled to tell you that Databend now fully works with New Expression after more than a half year of dedicated work. New Expression introduces a formal type system to Databend and supports type-safe downward casting , making the definition of functions easier.

New Expression is still being tuned, and a new version (v0.9) of Databend will be released once the tuning work is complete.

Learn More

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.

UNNEST

Function

The UNNEST function takes an array as a parameter, and returns a table containing each element of the array in a row.

Syntax

UNNEST(ARRAY) [WITH OFFSET]

If you're interested in becoming a contributor, helping us develop the

UNNEST

function would be a good start.

Issue 9549: Feature: Support

unnest

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.