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
1 heavysql> SELECT * FROM TABLE(generate_random_strings(10, 20); 2 id|rand_str 3 0 |He9UeknrGYIOxHzh5OZC 4 1 |Simnx7WQl1xRihLiH56u 5 2 |m5H1lBTOErpS8is00YJ 6 3 |eeDiNHfKzVQsSg0qHFS0 7 4 |JwOhUoQEI6Z0L78mj8jo 8 5 |kBTbSIMm25dvf64VMi 9 6 |W3lUUvC5ajm0W24JML 10 7 |XdtSQfdXQ85nvaIoyYUY 11 8 |iUTfGN5Jaj25LjGJhiRN 12 9 |72GUoTK2BzcBJVTgTGW
