ClickHouse / ClickHouse/ClickHouse

When I do parallel distributed INSERT SELECT, clickhouse-client reports `0 rows in set`

Open
#92,267 0 comments 0 reactions 0 assignees View on GitHub
comp-distributed minor unexpected behaviour
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

### Company or project name

ClickHouse

### Describe the unexpected behaviour

```
INSERT INTO wikistat WITH
parseDateTimeBestEffort(extract(_file, '^pageviews-([\\d\\-]+)\\.gz$')) AS time,
splitByChar(' ', line) AS values,
splitByChar('.', values[1]) AS projects
SELECT
time,
projects[1] AS project,
projects[2] AS subproject,
decodeURLComponent(values[2]) AS path,
toUInt64OrZero(values[3]) AS hits
FROM s3Cluster(default, 'https://clickhouse-public-datasets.s3.amazonaws.com/wikistat/original/pageviews*.gz', 'LineAsString')

Query id: 5eb7042f-66f0-439e-a6be-22c05d9f171d

Ok.

0 rows in set. Elapsed: 9315.611 sec. Processed 596.00 billion rows, 5.06 TB (63.98 million rows/s., 543.38 MB/s.)
Peak memory usage: 5.62 GiB.
```

### Which ClickHouse versions are affected?

master

### How to reproduce

^

### Expected behavior

We just recently made it to display the number of inserted rows for INSERTs, but it does not work for parallel distributed INSERT SELECT.

### Error message and/or stacktrace

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.