Skip to content

The s3 table function does well while url does not. #49234

@alexey-milovidov

Description

@alexey-milovidov

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)

Metadata

Metadata

Assignees

No one assigned

    Labels

    unexpected behaviourResult is unexpected, but not entirely wrong at the same time.warmup taskThe task for new ClickHouse team members. Low risk, moderate complexity, no urgency.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions