v.20.3New Feature
Add generateRandom Table Function for Random Row Generation
Add generateRandom table function to generate random rows with given schema. Allows to populate arbitrary test table with data. #8994 (Ilya Yatsishin)Why it matters
This feature enables users to easily populate arbitrary test tables with random data, facilitating testing and development scenarios without needing real datasets.How to use it
Use thegenerateRandom table function by specifying the desired schema to generate random rows. For example:SELECT * FROM generateRandom('id Int32, name String', 1000)This generates 1000 random rows with columns
id and name.