SQLData Manipulation (DML)System Table Functions

generate_random_strings

View as Markdown

Generates random string data.

SELECT * FROM TABLE(generate_random_strings(<num_strings>, <string_length>/)

Input Arguments

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

Output Columns

NameDescriptionData Type
idInteger id of output, starting at 0 and increasing monotonicallyColumn<BIGINT>
rand_strRandom StringColumn<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