## 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. |

atan2 | Trigonometric inverse tangent of the arithmetic dividend of the arguments. |

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 ... |