ClickHouse / ClickHouse/ClickHouse

The `s3` table function does well while `url` does not.

Open
#49,234 1 comment 0 reactions 0 assignees View on GitHub
comp-table-functions unexpected behaviour warmup task
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

**Describe the unexpected behaviour**

```
ip-172-31-5-46.eu-central-1.compute.internal :) SELECT count() FROM s3('https://clickhouse-public-datasets.s3.amazonaws.com/wikistat/original/pageviews-20200101-{0..10000}{0..10000}00.gz', LineAsString)

SELECT count()
FROM s3('https://clickhouse-public-datasets.s3.amazonaws.com/wikistat/original/pageviews-20200101-{0..10000}{0..10000}00.gz', LineAsString)

Query id: 06acf21e-6e68-47fb-9171-c754fd52c438

┌───count()─┐
│ 134599906 │
└───────────┘

1 row in set. Elapsed: 1.992 sec. Processed 133.99 million rows, 5.16 GB (67.28 million rows/s., 2.59 GB/s.)

ip-172-31-5-46.eu-central-1.compute.internal :) SELECT count() FROM url('https://clickhouse-public-datasets.s3.amazonaws.com/wikistat/original/pageviews-20200101-{0..10000}{0..10000}00.gz', LineAsString)

SELECT count()
FROM url('https://clickhouse-public-datasets.s3.amazonaws.com/wikistat/original/pageviews-20200101-{0..10000}{0..10000}00.gz', LineAsString)

Query id: 3dd33883-998d-4313-ac71-9962a97d3131

0 rows in set. Elapsed: 0.191 sec.

Received exception:
Code: 36. DB::Exception: Table function 'remote': first argument generates too many result addresses. (BAD_ARGUMENTS)
```

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.