GenerateRandom Table Engine

The GenerateRandom table engine produces random data for given table schema.

Usage examples:

• Use in test to populate reproducible large table.
• Generate random input for fuzzing tests.

使用法 in ClickHouse Server

The max_array_length and max_string_length parameters specify maximum length of all array or map columns and strings correspondingly in generated data.

Generate table engine supports only SELECT queries.

It supports all DataTypes that can be stored in a table except AggregateFunction.

例

1. Set up the generate_engine_table table:

2. Query the data:

実装の詳細

• Not supported:
  • ALTER
  • SELECT ... SAMPLE
  • INSERT
  • Indices
  • Replication