随机引擎

语法

CREATE TABLE table_name (
  column_name1 column_type1,
  column_name2 column_type2,
  ...
) ENGINE = Random;

使用场景

随机引擎用于生成随机数据以进行测试。如果在查询中未指定限制，它将使用 max_block_size 作为限制值。

示例：

> create table r (a int, b timestamp, c String, d Variant) Engine = Random;

> select * from r limit 3;

+-------------+----------------------------+-------+-----------------------------------------------------------------------------------------+
| a           | b                          | c     | d                                                                                       |
+-------------+----------------------------+-------+-----------------------------------------------------------------------------------------+
|  1515222693 | 5644-08-08 08:18:02.153307 | Cd4EL | false                                                                                   |
| -1721583430 | 2801-10-02 21:10:08.239880 | bdREv | {"2CbjY":5566179425126492090,"FtfVz":9111809212512345709,"VQuVv":-9022907531714095185}  |
| -1865622072 | 6158-08-16 19:03:47.563392 | wKcpg | {"7dZAZ":-6513853114735328596,"nkZOZ":-400420074545948308,"px9BO":-8839157034206468334} |
+-------------+----------------------------+-------+-----------------------------------------------------------------------------------------+