ABS
Learn how to use the ABS math function in PlaidCloud Lakehouse. Returns the absolute value of a number - see syntax, examples, and output.
Math Functions
This section provides reference information for the math functions in PlaidCloud Lakehouse.
ACOS
Learn how to use the ACOS math function in PlaidCloud Lakehouse. Returns the arc cosine of a number in radians - see syntax, examples, and output.
ASIN
Learn how to use the ASIN math function in PlaidCloud Lakehouse. Returns the arc sine of a number in radians - see syntax, examples, and output.
ATAN
Learn how to use the ATAN math function in PlaidCloud Lakehouse. Returns the arc tangent of a number in radians - see syntax, examples, and output.
ATAN2
Learn how to use the ATAN2 math function in PlaidCloud Lakehouse. Returns the arc tangent of y/x, using the signs to determine the quadrant.
BIN
Learn how to use the BIN math function in PlaidCloud Lakehouse. Returns the binary string representation of an integer - see syntax, examples, and output.
CBRT
Learn how to use the CBRT math function in PlaidCloud Lakehouse. Returns the cube root of a number - see syntax, examples, and output.
CEIL
Learn how to use the CEIL math function in PlaidCloud Lakehouse. Returns the smallest integer greater than or equal to a number - with syntax and examples.
CEILING
Learn how to use the CEILING math function in PlaidCloud Lakehouse. Returns the smallest integer greater than or equal to a number. Alias for CEIL.
CONV
Learn how to use the CONV math function in PlaidCloud Lakehouse. Converts a number from one base to another - see syntax, examples, and output.
COS
Learn how to use the COS math function in PlaidCloud Lakehouse. Returns the cosine of a number in radians - see syntax, examples, and output.
COSH
Learn how to use the COSH math function in PlaidCloud Lakehouse. Returns the hyperbolic cosine of a number - see syntax, examples, and output.
COSINE_SIMILARITY
Learn how to use the COSINE_SIMILARITY math function in PlaidCloud Lakehouse. Returns the cosine similarity between two arrays (vectors).
COSINE_SIMILARITY
Learn how to use the COSINE_SIMILARITY math function in PlaidCloud Lakehouse. Returns the cosine similarity between two arrays (vectors).
COSINE_SIMILARITY_NORM
Learn how to use the COSINE_SIMILARITY_NORM math function in PlaidCloud Lakehouse. Returns the cosine similarity between two normalized arrays.
COT
Learn how to use the COT math function in PlaidCloud Lakehouse. Returns the cotangent of a number in radians - see syntax, examples, and output.
DCEIL
Learn how to use the DCEIL math function in PlaidCloud Lakehouse. Alias for CEIL. See CEIL - see syntax, examples, and output.
DEGREES
Learn how to use the DEGREES math function in PlaidCloud Lakehouse. Converts radians to degrees - see syntax, examples, and output.
DEXP
Learn how to use the DEXP math function in PlaidCloud Lakehouse. Alias for EXP. See EXP - see syntax, examples, and output.
DFLOOR
Learn how to use the DFLOOR math function in PlaidCloud Lakehouse. Alias for FLOOR. See FLOOR - see syntax, examples, and output.
DIVIDE
Learn how to use the DIVIDE math function in PlaidCloud Lakehouse. Returns the result of dividing one number by another - see syntax, examples, and output.
DLOG1
Learn how to use the DLOG1 math function in PlaidCloud Lakehouse. Alias for LN. See LN - see syntax, examples, and output.
DLOG10
Learn how to use the DLOG10 math function in PlaidCloud Lakehouse. Alias for LOG10. See LOG10 - see syntax, examples, and output.
DPOW
Learn how to use the DPOW math function in PlaidCloud Lakehouse. Alias for POW. See POW - see syntax, examples, and output.
DROUND
Learn how to use the DROUND math function in PlaidCloud Lakehouse. Alias for ROUND. See ROUND - see syntax, examples, and output.
DSQRT
Learn how to use the DSQRT math function in PlaidCloud Lakehouse. Alias for SQRT. See SQRT - see syntax, examples, and output.
E
Learn how to use the E math function in PlaidCloud Lakehouse. Returns the mathematical constant e (Euler's number) - see syntax, examples, and output.
EXP
Learn how to use the EXP math function in PlaidCloud Lakehouse. Returns e raised to the power of a number - see syntax, examples, and output.
FLOOR
Learn how to use the FLOOR math function in PlaidCloud Lakehouse. Returns the largest integer less than or equal to a number - with syntax and examples.
FMOD
Learn how to use the FMOD math function in PlaidCloud Lakehouse. Returns the floating-point remainder of dividing two numbers - with syntax and examples.
FPOW
Learn how to use the FPOW math function in PlaidCloud Lakehouse. Alias for POW. See POW - see syntax, examples, and output.
GREATEST
Learn how to use the GREATEST math function in PlaidCloud Lakehouse. Returns the greatest value from a list of values - see syntax, examples, and output.
LEAST
Learn how to use the LEAST math function in PlaidCloud Lakehouse. Returns the smallest value from a list of values - see syntax, examples, and output.
LN
Learn how to use the LN math function in PlaidCloud Lakehouse. Returns the natural logarithm of a number - see syntax, examples, and output.
LOG
Learn how to use the LOG math function in PlaidCloud Lakehouse. Returns the logarithm of a number with a specified base - see syntax, examples, and output.
LOG10
Learn how to use the LOG10 math function in PlaidCloud Lakehouse. Returns the base-10 logarithm of a number - see syntax, examples, and output.
LOG2
Learn how to use the LOG2 math function in PlaidCloud Lakehouse. Returns the base-2 logarithm of a number - see syntax, examples, and output.
MOD
Learn how to use the MOD math function in PlaidCloud Lakehouse. Returns the remainder of dividing two numbers - see syntax, examples, and output.
MULTIPLY
Learn how to use the MULTIPLY math function in PlaidCloud Lakehouse. Returns the product of two numbers - see syntax, examples, and output.
NEGATIVE
Learn how to use the NEGATIVE math function in PlaidCloud Lakehouse. Returns the negation of a number - see syntax, examples, and output.
PI
Learn how to use the PI math function in PlaidCloud Lakehouse. Returns the mathematical constant pi - see syntax, examples, and output.
PMOD
Learn how to use the PMOD math function in PlaidCloud Lakehouse. Returns the positive modulus of dividing two numbers - see syntax, examples, and output.
POSITIVE
Learn how to use the POSITIVE math function in PlaidCloud Lakehouse. Returns the value unchanged (unary plus) - see syntax, examples, and output.
POW
Learn how to use the POW math function in PlaidCloud Lakehouse. Returns a number raised to the power of another number - see syntax, examples, and output.
POWER
Learn how to use the POWER math function in PlaidCloud Lakehouse. Returns a number raised to the power of another number. Alias for POW.
RADIANS
Learn how to use the RADIANS math function in PlaidCloud Lakehouse. Converts degrees to radians - see syntax, examples, and output.
RAND
Learn how to use the RAND math function in PlaidCloud Lakehouse. Returns a random floating-point value between 0 (inclusive) and 1 (exclusive).
RANDOM
Learn how to use the RANDOM math function in PlaidCloud Lakehouse. Returns a random floating-point value between 0 and 1. Alias for RAND.
ROUND
Learn how to use the ROUND math function in PlaidCloud Lakehouse. Rounds a number to a specified number of decimal places - with syntax and examples.
SIGN
Learn how to use the SIGN math function in PlaidCloud Lakehouse. Returns the sign of a number: -1, 0, or 1 - see syntax, examples, and output.
SIN
Learn how to use the SIN math function in PlaidCloud Lakehouse. Returns the sine of a number in radians - see syntax, examples, and output.
SINH
Learn how to use the SINH math function in PlaidCloud Lakehouse. Returns the hyperbolic sine of a number - see syntax, examples, and output.
SQRT
Learn how to use the SQRT math function in PlaidCloud Lakehouse. Returns the square root of a number - see syntax, examples, and output.
SQUARE
Learn how to use the SQUARE math function in PlaidCloud Lakehouse. Returns the square of a number - see syntax, examples, and output.
TAN
Learn how to use the TAN math function in PlaidCloud Lakehouse. Returns the tangent of a number in radians - see syntax, examples, and output.
TANH
Learn how to use the TANH math function in PlaidCloud Lakehouse. Returns the hyperbolic tangent of a number - see syntax, examples, and output.
TRUNCATE
Learn how to use the TRUNCATE math function in PlaidCloud Lakehouse. Truncates a number to a specified number of decimal places - with syntax and examples.