about maximum length of element of array in ClickHouse

166 views

Skip to first unread message

Cao Jack

unread,

Feb 6, 2020, 9:46:33 PM2/6/20

to ClickHouse

Hello every experts,

What about maximum length of element of array in ClickHouse

such as:

Array(String),Array(Int64),Array(int32)

from https://clickhouse-docs.readthedocs.io/en/latest/functions/array_functions.html

range(N)

Returns an array of numbers from 0 to N-1. Just in case, an exception is thrown if arrays with a total length of more than 100,000,000 elements are created in a data block.

It seems not more than 100,000,000 elements.

Please help to confirm.

Thanks a lot.

Sincerely Jack.

Denis Zhuravlev

unread,

Feb 7, 2020, 12:21:52 PM2/7/20

to ClickHouse

>What about maximum length of element of array in ClickHouse

There is no limit. Probably MaxUINT64 is the maximum length.

>range(N) 100,000,000 elements are created in a data block
It's a safety fuse against accidental mis-usage of range function.

Reply all

Reply to author

Forward

0 new messages