# Random Number (/docs/reference/sql/functions/random-number)



This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See [SQL interface scope](/docs/reference/clickhouse-compatibility#service-interfaces).

fuzzBits [#fuzzbits]

Flips the bits of the input string `s`, with probability `p` for each bit.

**Syntax**

```sql
fuzzBits(s, p)
```

**Arguments**

* `s` — String or FixedString to perform bit fuzzing on [`String`](/reference/data-types/string) or [`FixedString`](/reference/data-types/fixedstring)
* `p` — Probability of flipping each bit as a number between `0.0` and `1.0` [`Float*`](/reference/data-types/float)

**Returned value**

Returns a Fuzzed string with same type as `s`. [`String`](/reference/data-types/string) or [`FixedString`](/reference/data-types/fixedstring)

**Examples**

**Usage example**

```sql title=Query
SELECT fuzzBits(materialize('abacaba'), 0.1)
FROM numbers(3)
```

```text title=Response
┌─fuzzBits(materialize('abacaba'), 0.1)─┐
│ abaaaja                               │
│ a*cjab+                               │
│ aeca2A                                │
└───────────────────────────────────────┘
```

*Introduced in version 20.5.0.*

rand [#rand]

Returns a random `UInt32` number with uniform distribution.

Uses a linear congruential generator with an initial state obtained from the system, which means that while it appears random, it's not truly random and can be predictable if the initial state is known.
For scenarios where true randomness is crucial, consider using alternative methods like system-level calls or integrating with external libraries.

**Syntax**

```sql
rand([x])
```

**Arguments**

* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random number of type `UInt32`. [`UInt32`](/reference/data-types/int-uint)

**Examples**

**Usage example**

```sql title=Query
SELECT rand();
```

```text title=Response
1569354847
```

*Introduced in version 1.1.0.*

rand64 [#rand64]

Returns a random distributed `UInt64` number with uniform distribution.

Uses a linear congruential generator with an initial state obtained from the system, which means that while it appears random, it's not truly random and can be predictable if the initial state is known.
For scenarios where true randomness is crucial, consider using alternative methods like system-level calls or integrating with external libraries.

**Syntax**

```sql
rand64([x])
```

**Arguments**

* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random UInt64 number with uniform distribution. [`UInt64`](/reference/data-types/int-uint)

**Examples**

**Usage example**

```sql title=Query
SELECT rand64();
```

```text title=Response
15030268859237645412
```

*Introduced in version 1.1.0.*

randBernoulli [#randbernoulli]

Returns a random Float64 number drawn from a [Bernoulli distribution](https://en.wikipedia.org/wiki/Bernoulli_distribution).

**Syntax**

```sql
randBernoulli(probability[, x])
```

**Arguments**

* `probability` — The probability of success as a value between `0` and `1`. [`Float64`](/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified Bernoulli distribution. [`UInt64`](/reference/data-types/int-uint)

**Examples**

**Usage example**

```sql title=Query
SELECT randBernoulli(.75) FROM numbers(5)
```

```text title=Response
┌─randBernoulli(0.75)─┐
│                   1 │
│                   1 │
│                   0 │
│                   1 │
│                   1 │
└─────────────────────┘
```

*Introduced in version 22.10.0.*

randBinomial [#randbinomial]

Returns a random Float64 number drawn from a [binomial distribution](https://en.wikipedia.org/wiki/Binomial_distribution).

**Syntax**

```sql
randBinomial(experiments, probability[, x])
```

**Arguments**

* `experiments` — The number of experiments [`UInt64`](/reference/data-types/int-uint)
* `probability` — The probability of success in each experiment as a value between `0` and `1` [`Float64`](/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified binomial distribution. [`UInt64`](/reference/data-types/int-uint)

**Examples**

**Usage example**

```sql title=Query
SELECT randBinomial(100, .75) FROM numbers(5)
```

```text title=Response
┌─randBinomial(100, 0.75)─┐
│                      74 │
│                      78 │
│                      76 │
│                      77 │
│                      80 │
└─────────────────────────┘
```

*Introduced in version 22.10.0.*

randCanonical [#randcanonical]

Returns a random distributed `Float64` number with uniform distribution between `0` (inclusive) and `1` (exclusive).

**Syntax**

```sql
randCanonical([x])
```

**Arguments**

* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number. [`Float64`](/reference/data-types/float)

**Examples**

**Usage example**

```sql title=Query
SELECT randCanonical();
```

```text title=Response
0.345217890123456
```

*Introduced in version 22.11.0.*

randChiSquared [#randchisquared]

Returns a random Float64 number drawn from a [chi-square distribution](https://en.wikipedia.org/wiki/Chi-squared_distribution).

**Syntax**

```sql
randChiSquared(degree_of_freedom[, x])
```

**Arguments**

* `degree_of_freedom` — Degrees of freedom. [`Float64`](/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified chi-square distribution. [`Float64`](/reference/data-types/float)

**Examples**

**Usage example**

```sql title=Query
SELECT randChiSquared(10) FROM numbers(5)
```

```text title=Response
┌─randChiSquared(10)─┐
│ 10.015463656521543 │
│  9.621799919882768 │
│   2.71785015634699 │
│ 11.128188665931908 │
│  4.902063104425469 │
└────────────────────┘
```

*Introduced in version 22.10.0.*

randConstant [#randconstant]

Generates a single random value that remains constant across all rows in the current query execution.

This function:

* Returns the same random value for every row within a single query
* Produces different values across separate query executions

It is useful for applying consistent random seeds or identifiers across all rows in a dataset

**Syntax**

```sql
randConstant([x])
```

**Arguments**

* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a column of type `UInt32` containing the same random value in each row. [`UInt32`](/reference/data-types/int-uint)

**Examples**

**Basic usage**

```sql title=Query
SELECT randConstant() AS random_value;
```

```text title=Response
| random_value |
|--------------|
| 1234567890   |
```

**Usage with parameter**

```sql title=Query
SELECT randConstant(10) AS random_value;
```

```text title=Response
| random_value |
|--------------|
| 9876543210   |
```

*Introduced in version 1.1.0.*

randExponential [#randexponential]

Returns a random Float64 number drawn from an [exponential distribution](https://en.wikipedia.org/wiki/Exponential_distribution).

**Syntax**

```sql
randExponential(lambda[, x])
```

**Arguments**

* `lambda` — Rate parameter or lambda value of the distribution [`Float64`](/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified exponential distribution. [`Float64`](/reference/data-types/float)

**Examples**

**Usage example**

```sql title=Query
SELECT randExponential(1/10) FROM numbers(5)
```

```text title=Response
┌─randExponential(divide(1, 10))─┐
│              44.71628934340778 │
│              4.211013337903262 │
│             10.809402553207766 │
│              15.63959406553284 │
│             1.8148392319860158 │
└────────────────────────────────┘
```

*Introduced in version 22.10.0.*

randFisherF [#randfisherf]

Returns a random Float64 number drawn from an [F-distribution](https://en.wikipedia.org/wiki/F-distribution).

**Syntax**

```sql
randFisherF(d1, d2[, x])
```

**Arguments**

* `d1` — d1 degree of freedom in `X = (S1 / d1) / (S2 / d2)`. [`Float64`](/reference/data-types/float)
* `d2` — d2 degree of freedom in `X = (S1 / d1) / (S2 / d2)`. [`Float64`](/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified F-distribution [`Float64`](/reference/data-types/float)

**Examples**

**Usage example**

```sql title=Query
SELECT randFisherF(10, 3) FROM numbers(5)
```

```text title=Response
┌─randFisherF(10, 20)─┐
│  0.7204609609506184 │
│  0.9926258472572916 │
│  1.4010752726735863 │
│ 0.34928401507025556 │
│  1.8216216009473598 │
└─────────────────────┘
```

*Introduced in version 22.10.0.*

randLogNormal [#randlognormal]

Returns a random Float64 number drawn from a [log-normal distribution](https://en.wikipedia.org/wiki/Log-normal_distribution).

**Syntax**

```sql
randLogNormal(mean, stddev[, x])
```

**Arguments**

* `mean` — The mean value of distribution. [`Float64`](/reference/data-types/float)
* `stddev` — The standard deviation of the distribution. [`Float64`](/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified log-normal distribution. [`Float64`](/reference/data-types/float)

**Examples**

**Usage example**

```sql title=Query
SELECT randLogNormal(100, 5) FROM numbers(5)
```

```text title=Response
┌─randLogNormal(100, 5)─┐
│  1.295699673937363e48 │
│  9.719869109186684e39 │
│  6.110868203189557e42 │
│  9.912675872925529e39 │
│ 2.3564708490552458e42 │
└───────────────────────┘
```

*Introduced in version 22.10.0.*

randNegativeBinomial [#randnegativebinomial]

Returns a random Float64 number drawn from a [negative binomial distribution](https://en.wikipedia.org/wiki/Negative_binomial_distribution).

**Syntax**

```sql
randNegativeBinomial(experiments, probability[, x])
```

**Arguments**

* `experiments` — The number of experiments. [`UInt64`](/reference/data-types/int-uint)
* `probability` — `The probability of failure in each experiment as a value between `0`and`1`. [`Float64\`]\(/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified negative binomial distribution [`UInt64`](/reference/data-types/int-uint)

**Examples**

**Usage example**

```sql title=Query
SELECT randNegativeBinomial(100, .75) FROM numbers(5)
```

```text title=Response
┌─randNegativeBinomial(100, 0.75)─┐
│                              33 │
│                              32 │
│                              39 │
│                              40 │
│                              50 │
└─────────────────────────────────┘
```

*Introduced in version 22.10.0.*

randNormal [#randnormal]

Returns a random Float64 number drawn from a [normal distribution](https://en.wikipedia.org/wiki/Normal_distribution).

**Syntax**

```sql
randNormal(mean, stddev[, x])
```

**Arguments**

* `mean` — The mean value of distribution [`Float64`](/reference/data-types/float)
* `stddev` — The standard deviation of the distribution [`Float64`](/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified normal distribution. [`Float64`](/reference/data-types/float)

**Examples**

**Usage example**

```sql title=Query
SELECT randNormal(10, 2) FROM numbers(5)
```

```text title=Response
┌──randNormal(10, 2)─┐
│ 13.389228911709653 │
│  8.622949707401295 │
│ 10.801887062682981 │
│ 4.5220192605895315 │
│ 10.901239123982567 │
└────────────────────┘
```

*Introduced in version 22.10.0.*

randPoisson [#randpoisson]

Returns a random Float64 number drawn from a [Poisson distribution](https://en.wikipedia.org/wiki/Poisson_distribution) distribution.

**Syntax**

```sql
randPoisson(n[, x])
```

**Arguments**

* `n` — The mean number of occurrences. [`UInt64`](/reference/data-types/int-uint)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified Poisson distribution. [`UInt64`](/reference/data-types/int-uint)

**Examples**

**Usage example**

```sql title=Query
SELECT randPoisson(10) FROM numbers(5)
```

```text title=Response
┌─randPoisson(10)─┐
│               8 │
│               8 │
│               7 │
│              10 │
│               6 │
└─────────────────┘
```

*Introduced in version 22.10.0.*

randStudentT [#randstudentt]

Returns a random Float64 number drawn from a [Student's t-distribution](https://en.wikipedia.org/wiki/Student%27s_t-distribution).

**Syntax**

```sql
randStudentT(degree_of_freedom[, x])
```

**Arguments**

* `degree_of_freedom` — Degrees of freedom. [`Float64`](/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random Float64 number drawn from the specified Student's t-distribution. [`Float64`](/reference/data-types/float)

**Examples**

**Usage example**

```sql title=Query
SELECT randStudentT(10) FROM numbers(5)
```

```text title=Response
┌─────randStudentT(10)─┐
│   1.2217309938538725 │
│   1.7941971681200541 │
│ -0.28192176076784664 │
│   0.2508897721303792 │
│  -2.7858432909761186 │
└──────────────────────┘
```

*Introduced in version 22.10.0.*

randUniform [#randuniform]

Returns a random Float64 number drawn uniformly from the interval $\[\min, \max]$.

**Syntax**

```sql
randUniform(min, max[, x])
```

**Arguments**

* `min` — Left boundary of the range (inclusive). [`Float64`](/reference/data-types/float)
* `max` — Right boundary of the range (inclusive). [`Float64`](/reference/data-types/float)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a random number drawn uniformly from the interval formed by `min` and `max`. [`Float64`](/reference/data-types/float)

**Examples**

**Usage example**

```sql title=Query
SELECT randUniform(5.5, 10) FROM numbers(5)
```

```text title=Response
┌─randUniform(5.5, 10)─┐
│    8.094978491443102 │
│   7.3181248914450885 │
│    7.177741903868262 │
│    6.483347380953762 │
│    6.122286382885112 │
└──────────────────────┘
```

*Introduced in version 22.10.0.*

randomFixedString [#randomfixedstring]

Generates a random fixed-size string with the specified number of character.
The returned characters are not necessarily ASCII characters, i.e. they may not be printable.

**Syntax**

```sql
randomFixedString(length)
```

**Arguments**

* `length` — Length of the string in bytes. [`UInt*`](/reference/data-types/int-uint)

**Returned value**

Returns a string filled with random bytes. [`FixedString`](/reference/data-types/fixedstring)

**Examples**

**Usage example**

```sql title=Query
SELECT randomFixedString(13) AS rnd, toTypeName(rnd)
```

```text title=Response
┌─rnd────────┬─toTypeName(randomFixedString(13))─┐
│ j▒h㋖HɨZ'▒ │ FixedString(13)                   │
└────────────┴───────────────────────────────────┘
```

*Introduced in version 20.5.0.*

randomPrintableASCII [#randomprintableascii]

Generates a random [ASCII](https://en.wikipedia.org/wiki/ASCII#Printable_characters) string with the specified number of characters.

If you pass `length < 0`, the behavior of the function is undefined.

**Syntax**

```sql
randomPrintableASCII(length[, x])
```

**Arguments**

* `length` — String length in bytes. [`(U)Int*`](/reference/data-types/int-uint)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a string with a random set of ASCII printable characters. [`String`](/reference/data-types/string)

**Examples**

**Usage example**

```sql title=Query
SELECT number, randomPrintableASCII(30) AS str, length(str) FROM system.numbers LIMIT 3
```

```text title=Response
┌─number─┬─str────────────────────────────┬─length(randomPrintableASCII(30))─┐
│      0 │ SuiCOSTvC0csfABSw=UcSzp2.`rv8x │                               30 │
│      1 │ 1Ag NlJ &RCN:*>HVPG;PE-nO"SUFD │                               30 │
│      2 │ /"+<"with:=LjJ Vm!c&hI*m#XTfzz │                               30 │
└────────┴────────────────────────────────┴──────────────────────────────────┘
```

*Introduced in version 20.1.0.*

randomString [#randomstring]

Generates a random string with the specified number of characters.
The returned characters are not necessarily ASCII characters, i.e. they may not be printable.

**Syntax**

```sql
randomString(length[, x])
```

**Arguments**

* `length` — Length of the string in bytes. [`(U)Int*`](/reference/data-types/int-uint)
* `x` — Optional and ignored. The only purpose of the argument is to prevent [common subexpression elimination](/reference/functions/regular-functions/overview#common-subexpression-elimination) when the same function call is used multiple times in a query. [`Any`](/reference/data-types)

**Returned value**

Returns a string filled with random bytes. [`String`](/reference/data-types/string)

**Examples**

**Usage example**

```sql title=Query
SELECT randomString(5) AS str FROM numbers(2)
```

```text title=Response
���
�v6B�
```

*Introduced in version 20.5.0.*

randomStringUTF8 [#randomstringutf8]

Generates a random [UTF-8](https://en.wikipedia.org/wiki/UTF-8) string with the specified number of codepoints.
No codepoints from unassigned [planes](https://en.wikipedia.org/wiki/Plane_\(Unicode\)) (planes 4 to 13) are returned.
It is still possible that the client interacting with RawTree server is not able to display the produced UTF-8 string correctly.

**Syntax**

```sql
randomStringUTF8(length)
```

**Arguments**

* `length` — Length of the string in code points. [`(U)Int*`](/reference/data-types/int-uint)

**Returned value**

Returns a string filled with random UTF-8 codepoints. [`String`](/reference/data-types/string)

**Examples**

**Usage example**

```sql title=Query
SELECT randomStringUTF8(13)
```

```text title=Response
┌─randomStringUTF8(13)─┐
│ 󶡕𲉗𩍄ԍ╃𑄅󦨁󷌁󬾣𹼫󤓆󺜘󩶧         │
└──────────────────────┘
```

*Introduced in version 20.5.0.*
