Comment on page
generate_random_strings
Generates random string data.
SELECT * FROM TABLE(generate_random_strings(<num_strings>, <string_length>/)
Parameter | Description | Data Type |
|---|---|---|
<num_strings> | The number of strings to randomly generate. | BIGINT |
<string_length> | Length of the generated strings. | BIGINT |
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