ClickHouse / ClickHouse/ClickHouse
When I do parallel distributed INSERT SELECT, clickhouse-client reports `0 rows in set`
- 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
Assessment
This issue has not been assessed yet.