sqrt

Description

Returns the square root for a given input and null if input is negative.

Return type

float64

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

sqrt(arg)

Argument

Type

Optional

Repeatable

Restrictions

arg

numeric

no

no

none

Examples

make_col squareroot:sqrt(@.x)

Create a column ‘squareroot’ with the result of the square root of column ‘x’