v7.2.0 (latest)
Search
K
Comment on page

generate_random_strings

Generates random string data.
SELECT * FROM TABLE(generate_random_strings(<num_strings>, <string_length>/)

Input Arguments

Parameter
Description
Data Type
<num_strings>
The number of strings to randomly generate.
BIGINT
<string_length>
Length of the generated strings.
BIGINT

Output Columns

Name
Description
Data Type
id
Integer id of output, starting at 0 and increasing monotonically
Column<BIGINT>
rand_str
Random String
Column<TEXT ENCODING DICT>
Example
heavysql> SELECT * FROM TABLE(generate_random_strings(10, 20);
id|rand_str
0 |He9UeknrGYIOxHzh5OZC
1 |Simnx7WQl1xRihLiH56u
2 |m5H1lBTOErpS8is00YJ
3 |eeDiNHfKzVQsSg0qHFS0
4 |JwOhUoQEI6Z0L78mj8jo
5 |kBTbSIMm25dvf64VMi
6 |W3lUUvC5ajm0W24JML
7 |XdtSQfdXQ85nvaIoyYUY
8 |iUTfGN5Jaj25LjGJhiRN
9 |72GUoTK2BzcBJVTgTGW
Last modified 9mo ago