Generic Functions

Method Definition
apply Applies any Vertica function on the input expressions.

Analytical & Aggregate Functions

Method Definition
avg Computes the average (arithmetic mean) of an expression over a group of rows.
bool_and Processes Boolean values and returns a Boolean value result. If all input values are true, BOOL_AND returns True. Otherwise it returns False.
bool_or Processes Boolean values and returns a Boolean value result. If at least one input value is true, BOOL_OR returns True. Otherwise, it returns False.
bool_xor Processes Boolean values and returns a Boolean value result. If specifically only one input value is true, BOOL_XOR returns True. Otherwise, it returns False.
conditional_change_event Assigns an event window number to each row, starting from 0, and increments by 1 when the result of evaluating the argument expression on the current row differs from that on the previous row.
conditional_true_event Assigns an event window number to each row, starting from 0, and increments the number by 1 when the result of the boolean argument expression evaluates true.
count Returns as a BIGINT the number of rows in each group where the expression is not NULL.
lag Returns the value of the input expression at the given offset before the current row within a window.
lead Returns values from the row after the current row within a window, letting you access more than one row in a table at the same time.
max Returns the greatest value of an expression over a group of rows.
median Computes the approximate median of an expression over a group of rows.
min Returns the smallest value of an expression over a group of rows.
nth_value Returns the value evaluated at the row that is the nth row of the window (counting from 1).
quantile Computes the approximate percentile of an expression over a group of rows.
std Evaluates the statistical sample standard deviation for each member of the group.
sum Computes the sum of an expression over a group of rows.
var Evaluates the sample variance for each row of the group.

String Functions

Method Definition
length Returns the length of a string.
lower Returns a VARCHAR value containing the argument converted to lowercase letters.
substr Returns VARCHAR or VARBINARY value representing a substring of a specified string.
upper Returns a VARCHAR value containing the argument converted to uppercase letters.

Mathematical Functions

Method Definition
abs Absolute Value.
acos Trigonometric Inverse Cosine.
asin Trigonometric Inverse Sine.
atan Trigonometric Inverse Tangent.
cbrt Cube Root.
ceil Ceiling Function.
comb Number of ways to choose k items from n items.
cos Trigonometric Cosine.
cosh Hyperbolic Cosine.
cot Trigonometric Cotangent.
degrees Converts Radians to Degrees.
distance Returns the distance (in kilometers) between two points.
exp Exponential.
factorial Factorial.
floor Floor Function.
gamma Gamma Function.
hash Calculates a hash value over the function arguments.
isfinite Returns True if the expression is finite.
isinf Returns True if the expression is infinite.
isnan Returns True if the expression is NaN.
lgamma Natural Logarithm of the expression Gamma.
ln Natural Logarithm.
log Logarithm.
radians Converts Degrees to Radians.
random Returns a Random Number.
randomint Returns a Random Number from 0 through n – 1.
rank Within each window partition, ranks all rows in the query results set according to the order specified by the window's ORDER BY clause.
round Rounds the expression.
row_number Assigns a sequence of unique numbers, starting from 1, to each row in a window partition.
seeded_random Returns a Seeded Random Number using the input random state.
sign Sign of the expression.
sin Trigonometric Sine.
sinh Hyperbolic Sine.
sqrt Arithmetic Square Root.
tan Trigonometric Tangent.
tanh Hyperbolic Tangent.
trunc Truncates the expression.

Mathematical Variables

variables Pi, e, tau ...