Help wanted!

The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.

Help ClickHouse documentation by editing this page

generateRandom

使用给定的模式生成随机数据。
允许用数据填充测试表。
支持可以存储在表中的所有数据类型，除了 LowCardinality 和 AggregateFunction.

  1. generateRandom('name TypeName[, name TypeName]...', [, 'random_seed'[, 'max_string_length'[, 'max_array_length']]]);

参数

  • name — Name of corresponding column.
  • TypeName — Type of corresponding column.
  • max_array_length — Maximum array length for all generated arrays. Defaults to 10.
  • max_string_length — Maximum string length for all generated strings. Defaults to 10.
  • random_seed — Specify random seed manually to produce stable results. If NULL — seed is randomly generated.

返回值

具有请求架构的表对象。

用法示例

  1. SELECT * FROM generateRandom('a Array(Int8), d Decimal32(4), c Tuple(DateTime64(3), UUID)', 1, 10, 2) LIMIT 3;
  1. ┌─a────────┬────────────d─┬─c──────────────────────────────────────────────────────────────────┐
  2. │ [77]     │ -124167.6723 │ ('2061-04-17 21:59:44.573','3f72f405-ec3e-13c8-44ca-66ef335f7835') │
  3. │ [32,110] │ -141397.7312 │ ('1979-02-09 03:43:48.526','982486d1-5a5d-a308-e525-7bd8b80ffa73') │
  4. │ [68]     │  -67417.0770 │ ('2080-03-12 14:17:31.269','110425e5-413f-10a6-05ba-fa6b3e929f15') │
  5. └──────────┴──────────────┴────────────────────────────────────────────────────────────────────┘

原始文章