跳转至

Normal random number（正态随机数(Normal random number)）

Supported in: Batch, Faster, Streaming

Returns a column of normally distributed random numbers with zero mean and unit variance. This is not deterministic and will not produce the same result on repeated builds, even when using a seed.

Expression categories: Numeric

Declared arguments

  • optional Seed: Adding a seed means that the random numbers will be generated from same sequence at each build. If you want true random numbers this should not be supplied. A seed will not produce fully deterministic results since compute may run distributed and the order in which random numbers are pulled for rows is not guaranteed.
    Literal\

Output type: Double

中文翻译

正态随机数(Normal random number)

支持环境：批处理(Batch)、快速处理(Faster)、流处理(Streaming)

返回均值为零、方差为一的正态分布随机数列。该函数不具有确定性，即使使用种子(seed)，在重复构建时也不会产生相同结果。

表达式类别： 数值型(Numeric)

声明参数(Declared arguments)

  • 可选 种子(Seed)： 添加种子意味着每次构建时将从相同序列生成随机数。如需真正的随机数，则不应提供此参数。由于计算可能以分布式方式运行，且行级随机数的提取顺序无法保证，因此种子无法产生完全确定性的结果。
    字面量\<长整型>(Literal\)

输出类型： 双精度浮点型(Double)