9951 explained code solutions for 126 technologies

clickhouseGenerate test data for a table

This query will insert 10k rows into tbl rable:

INSERT INTO tbl(date, val) SELECT today(), number FROM numbers(10000)ctrl + c

table to insert generated data to

date, val

columns to fill with generated data


set today value for date column

, number

set number value for col column


will generate 10k rows with number column value in a 1...10000 range