Clickhouse如何循环遍历，生成随机数

1、生成20长度数字字符串的随机数据

select substring(toString(rand64()), 1, 20) as randomNumber

2、500以内数字生成500以内的随机数组

select arraySlice(arraySort(x -> rand(), range(1, 501)), 1, rand() % 500 + 1) as arr

2.1、500以内数字生成10个随机数组

select arraySlice(arraySort(x -> rand(), range(1, 501)), 1, 10) as arr

select arraySlice(arraySort(x -> x.1, arrayMap(x -> (rand64(x), x), range(1, 501))), 1, 10).2

3、生成一个bitmap

select bitmapBuild([1,2,3,4])

4、循环遍历0，99

select toInt64(number) as num from numbers(100)

4.1、遍历100到199

select toInt64(number) as num from numbers(100,100)