Bohu

**Summary** A query digest is a summary of a query, and if two queries have the same digest, it means they share the same pattern. These two query digests are...

feat: query forward

4

**Summary** Assuming we have a Databend cluster with three nodes, each serving as a service: Node-1: Create a query ID X. If the query is sent to Node-2 but not...

tracking: inverted index benchmark

2

**Summary** **Version** https://github.com/datafuselabs/databend/releases/tag/v1.2.393-nightly **Table** ``` CREATE OR REPLACE TABLE log ( user_id INT, log_json VARIANT, time TIMESTAMP, url VARCHAR AS (log_json['request_url']::VARCHAR) STORED ); CREATE OR REPLACE INVERTED INDEX idx_url ON...

**Summary** Query: In a write warehouse(cluster_id: w1), we can set: ``` set warehouse max_threads = 4; ``` In a query warehouse(cluster_id: w2), we can set: ``` set warehouse max_threads =...

bug: copy into table source can't contain window|aggregate|udf|join functions

1

From slack thread: https://databend.slack.com/archives/C01QT5FFH34/p1711111928944469?thread_ts=1711035878.476569&channel=C01QT5FFH34&message_ts=1711111928.944469 Made a quick example which illustrates this: ``` cat string.json {"field1": "this%20is%20text"} {"field1": "this%20is%20another%20text"} aws s3 cp string.json s3://../_tmp_table/ CREATE TABLE raw._tmp_table (field1 VARCHAR); COPY INTO...

copy tsv.gz 3X faster than csv.gz

3

**Summary** From @youngsofun information , copy `tsv.gz` performance should same as `csv.gz`. From the profile, **tsv.gz bytes scanned 15GB cost 9 minutes but csv.gz scanned 75GB cost 26 minutes** ##...

test: Simplify test file naming for easier expansion

1

**Summary** now: `05_0019_ddl_create_view.test` after: `05_ddl_create_view.test` It's easy to add new test file.