The limit on the maximum number of generated addresses cannot be changed for function url

[alexey-milovidov]

play-eu :) SELECT _path, count() FROM url('https://clickhouse-public-datasets.s3.amazonaws.com/wikistat/original/pageviews-20200101-{00..23}{00..59}00.gz', LineAsString) GROUP BY _path ORDER BY _path

SELECT
    _path,
    count()
FROM url('https://clickhouse-public-datasets.s3.amazonaws.com/wikistat/original/pageviews-20200101-{00..23}{00..59}00.gz', LineAsString)
GROUP BY _path
ORDER BY _path ASC

Query id: 90cd5580-a567-4af1-9b6f-ea99035053b1


0 rows in set. Elapsed: 0.022 sec. 

Received exception from server (version 23.4.1):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Table function 'remote': first argument generates too many result addresses. (BAD_ARGUMENTS)

play-eu :) SET table_function_remote_max_addresses = 1000000

SET table_function_remote_max_addresses = 1000000

Query id: 31702a49-0a8b-4580-88fc-a87ef2079764

Ok.

0 rows in set. Elapsed: 0.001 sec. 

play-eu :) SELECT _path, count() FROM url('https://clickhouse-public-datasets.s3.amazonaws.com/wikistat/original/pageviews-20200101-{00..23}{00..59}00.gz', LineAsString) GROUP BY _path ORDER BY _path

SELECT
    _path,
    count()
FROM url('https://clickhouse-public-datasets.s3.amazonaws.com/wikistat/original/pageviews-20200101-{00..23}{00..59}00.gz', LineAsString)
GROUP BY _path
ORDER BY _path ASC

Query id: 1e18851a-f9d7-43e4-84ef-3ffd34fb4b14


0 rows in set. Elapsed: 0.001 sec. 

Received exception from server (version 23.4.1):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Table function 'remote': first argument generates too many result addresses. (BAD_ARGUMENTS)

Also, take a look at the exception message. It is wrong.

[Ziy1-Tan]

take

[Ziy1-Tan]

@alexey-milovidov Seems like SET glob_expansion_max_elements = 1000000 will work for function url?

[alexey-milovidov]

@Ziy1-Tan ok. Then only the error message has to be fixed.