- Categories:
RANDSTR¶
Returns a random string of specified length
.
Syntax¶
RANDSTR( <length> , <gen> )
Usage notes¶
Individual characters are chosen uniformly at random from the following pool of characters: 0-9, a-z, A-Z.
The value for the generator expression,
gen
, is used as the seed for this uniform random distribution. For more information about generator expressions, see Usage notes.
Examples¶
SELECT randstr(5, random()) FROM table(generator(rowCount => 5));
+----------------------+
| RANDSTR(5, RANDOM()) |
|----------------------|
| rM6ep |
| nsWJ0 |
| IQi5H |
| VBNvY |
| wjk6y |
+----------------------+
SELECT randstr(5, 1234) FROM table(generator(rowCount => 5));
+------------------+
| RANDSTR(5, 1234) |
|------------------|
| E5tav |
| E5tav |
| E5tav |
| E5tav |
| E5tav |
+------------------+
SELECT randstr(abs(random()) % 10, random()) FROM table(generator(rowCount => 5));
+---------------------------------------+
| RANDSTR(ABS(RANDOM()) % 10, RANDOM()) |
|---------------------------------------|
| e |
| iR |
| qRwWl7W6 |
| |
| Yg |
+---------------------------------------+