天天看点

This week in Databend #19

Databend aimed to be an open source elastic and reliable cloud warehouse, it offers blazing fast query and combines elasticity, simplicity, low cost of the cloud, built to make the Data Cloud easy.

Below is a list of some major changes that we don't want you to miss.

add query log table write by @BohuTANG. (#3273)

return nodes list in metasrv server by @sunisdown. (#2943)

support create stage statement by @GrapeBaBa. (#3253)

default expression support by @sundy-li. (#3282)

add system.query_log by @SGZW. (#3234)

add revoke statement by @flaneur2020. (#3194)

add strings functions

<code>INSTR</code>, <code>FIELD</code>, <code>SUBSTRING</code>, <code>SUBSTR</code>, <code>MID</code>, <code>SUBSTRING_INDEX</code>, <code>REVERSE</code>, <code>REPLACE</code>, <code>STRCMP</code>, <code>SPACE</code>, <code>LEFT</code>, <code>RIGHT</code>, <code>LPAD</code>, <code>RPAD</code>, <code>CHARACTER_LENGTH</code>, <code>CHAR_LENGTH</code>, <code>ORD</code> by @mshauneu (#3217, #3215, #3231, etc.)

<code>bin_length</code> by @radmirnovii (#3232)

<code>octet_length</code> by @unconsolable (#3227)

<code>trim</code> by @QuantumBear (#3196)

<code>CONCAT</code>, <code>CONCAT_WS</code> by @Veeupup (#3214, #3260)

replace AppendOperationLogEntry vec[] with stream by @junli1026 (#3296)

support create table like statement by @junli1026 (#3292)

show table options by @Junnplus (#3252)

make <code>StateMachine::apply</code> use transaction to perform operations by @ariesdevil. (#3102)

complete dates function monotonicity check by @zhyass. (#3228)

http: refine the mod import and add http usage function by @BohuTANG. (#3246)

refactoring insert interpreter by @dantengsky. (#3226)

[common/function] simplify get_layout_offsets by @drmingdrmer (#3223)

add monotonicity in range filter by @zhyass. (#3195)

introduce compact statement by @dantengsky. (#3182)

string performence improvement by @Veeupup. (#3288)

fix try_from_literal by @dust1. (#3197)

fix github table engine inits by @BohuTANG. (#3204)

Let's learn a weekly tip from Databend.

Databend now supports GitHub as a data source, and you can read the relevant code at storages/github.

create github-engine based database

Before running databend, your Github Access Token should be set.

Create a Github powered database.

show all tables

Show all tables in this database, which are currently flattened. This means that Repos, issues and PRs are all in the form of tables.

View basic information about a repo

You can check the changelogs of Databend nightly to learn about our latest developments.

v0.5.38-nightly

v0.5.37-nightly

v0.5.36-nightly

v0.5.35-nightly

v0.5.34-nightly

v0.5.33-nightly

v0.5.32-nightly

From open source, for open source. Our team is also committed to contributing to the Rust ecosystem and upstream dependencies.

arrow2 #641 &amp; #664: Add lower and upper support for string. by @Xuanwo

arrow2 #651: Improved performance in cast Primitive to Binary/String again (4x): <code>Memcpy</code> style write, no extra copy. by @sundy-li

Please join the DatafuseLabs Community if you are interested in Databend.

We are looking forward to seeing you try our code. We have a strong team behind you to ensure a smooth experience in trying our code for your projects.

If you are a hacker passionate about database internals, feel free to play with our code.

You can submit issues for any problems you find. We also highly appreciate any of your pull requests.

Databend Website

Twitter

GitHub Discussions

Slack Channel