Math Query Functions

Humio's query functions take a set of events, parameters, or configurations; and produce, reduce, or modify values within that set, or within the events themselves within the query pipeline.

FunctionDescription
base64Decode()Performs Base64 decoding of a field.
math:abs()Calculates the absolute value of a field.
math:arccos()Calculates the arc cosine of a field.
math:arcsin()Calculates the arc sine of a field.
math:arctan()Calculates the arc tangent of a value.
math:arctan2()Calculates the arc tangent of a value.
math:ceil()Rounds field value to smallest integer that's larger than or equal to it.
math:cos()Calculates the cosine of a field.
math:cosh()Returns the hyperbolic cosine of a double field.
math:deg2rad()Converts angles from degrees to radians.
math:exp()Calculates Euler's number e raised to the power of a double value in a field.
math:expm1()Returns the exponential value of a number minus 1.
math:floor()Returns largest integer value not greater than the field value given.
math:log()Calculates the natural logarithm (base e) of the value in a double field.
math:log10()Calculates the base 10 logarithm of a double field.
math:log1p()Calculates the natural logarithm of the sum of field's value and 1.
math:log2()Calculates the base 2 logarithm of a double field.
math:mod()Calculates the floor modulus of field value and the divisor.
math:pow()Calculates the field value to the exponent power.
math:rad2deg()Converts angles from radians to degrees.
math:sin()Calculates the sine of a field.
math:sinh()Calculates the hyperbolic sine of a double field.
math:spherical2cartesian()Calculates the average for a field of a set of events.
math:sqrt()Calculates the rounded positive square root of a double field.
math:tan()Calculates the trigonometric tangent of an angle in a field.
math:tanh()Calculates the hyperbolic tangent of a field.
round()Rounds an input field up or down, depending on which is nearest.
unit:convert()Converts values between different units.

Table: Math Query Functions