Calculated functions

This page links to all of the calculated functions available in Upsolver.

Aerospike functions

• AEROSPIKE_KV

Array functions

• ARRAY_MAX

• ARRAY_MIN

• ARRAY_SUM

• CONCAT

• COUNT_VALUES

• COUNT_VALUES_IF

• DISTINCT_VALUES

• ELEMENT_AT

• FIRST_ELEMENT

• LAST_ELEMENT

• LEAST

Conditional functions

• COALESCE

• IF_ELSE

• NULL_IF

Date functions

• ADD_TIME_ZONE_OFFSET

• BETWEEN

• DATE_FORMAT

• PARSE_DATE

• TO_UNIX_EPOCH_MILLIS

• TO_UNIX_EPOCH_SECONDS

• UNIX_EPOCH_TO_DATE

External API functions

• GEO_IP

• USER_AGENT_PARSER

• WURFL_USER_AGENT

Filter functions

• AND

• BETWEEN

• CONTAINS

• EQUAL_TO

• EXISTS

• GREATER_THAN

• GREATER_THAN_OR_EQUAL_TO

• IN_SET

• IS_DUPLICATE

• LESS_THAN

• LESS_THAN_OR_EQUAL_TO

• NOT

• NOT_EQUAL_TO

• OR

• RANDOM

• XOR

Numeric functions

• ABS

• ADD

• CEILING

• COS

• DEGREES

• DIVIDE

• EXP

• FLOOR

• GET_PROCESSING_TIME

• GREATEST

• INTEGER_DIVIDE

• LN

• LOG

• MOD

• MULTIPLY

• NEGATE

• POWER

• RADIANS

• RECIPROCAL

• ROUND

• SIGN

• SIN

• SQRT

• SQUARE

• SUBTRACT

• TAN

• TAN_H

• TRUNC

Spatial functions

• WKT_SPATIAL_CONTAINS

• WKT_SPATIAL_INTERSECT

String functions

• BASE64_DECODE

• BYTES_SUBSTRING

• JOIN_ARRAYS

• MD5

• REGEX

• REGEX_MATCH_POSITION

• REGEX_NAMED_GROUPS

• REPLACE

• SHA1

• SHA256

• SPLIT

• SPLIT_TO_RECORD

• STRING_FORMAT

• STRING_LENGTH

• STRIP_MARGIN

• STRIP_PREFIX

• STRIP_SUFFIX

• SUBSTRING

• TOP_PRIVATE_DOMAIN

• TO_LOWER

• TO_UPPER

• TRANSLATE

• TRIM

• TRIM_CHARS

• URL_DECODE

• URL_ENCODE

• URL_PARSER

• UUID_GENERATOR

Structural functions

• FROM_KEY_VALUE

• GET_RANGE

• ITEM_INDEX

• JSON_PATH

• JSON_TO_RECORD

• MAP_WITH_INDEX

• QUERY_STRING_TO_RECORD

• TO_ARRAY

• ZIP

Type conversion functions

• HEX_TO_DECIMAL

• TO_DOUBLE

• TO_FLOAT

• TO_INT

• TO_LONG

• TO_NUMBER

• TO_STRING