Sometimes we need test data. So Clickhouse has built-in generateRandom()
function that helps quickly generate and populate data into tables of any structure.
Generates random data with given schema. Allows to populate test tables with data. Supports all data types that can be stored in table except LowCardinality
and AggregateFunction
.
generateRandom('name TypeName[, name TypeName]...', [, 'random_seed'[, 'max_string_length'[, 'max_array_length']]])