Skip to main content

Celonis Product Documentation

Supported Vertica functions for case-centric transformations

Not all Vertica functions are enabled for transformations. The functions on this list are enabled for use in transformations for case-centric process mining. For their descriptions, see the Vertica documentation.

The list of enabled functions for object-centric transformations is different. You can find it at Supported functions for object-centric transformations.

  • ABS

  • ACOS

  • ADD_DAYS

  • ADD_MONTHS

  • ADD_SECONDS

  • ANALYZE_STATISTICS

  • ANALYZE_STATISTICS_PARTITION

  • ASIN

  • ATAN

  • AVG

  • BTRIM

  • CAST

  • CBRT

  • CEILING

  • CEIL

  • CHARACTER_LENGTH

  • CHARINDEX

  • CHAR_LENGTH

  • COALESCE

  • COLLATION

  • CONCAT

  • CONVERT

  • CORR

  • COS

  • COUNT

  • COPY_TABLE

  • CURDATE

  • CURRENT_DATE

  • CURRENT_TIME

  • CURRENT_TIMESTAMP

  • CUSTOM_BOSCH_SLEEP

  • DATALENGTH

  • DATE

  • DATEADD

  • DATEDIFF

  • DATEFROMPARTS

  • DATENAME

  • DATEPART

  • DATE_PART

  • DATE_TRUNC

  • DAY

  • DAYOFMONTH

  • DAYOFWEEK

  • DAYOFWEEK_ISO

  • DAYOFYEAR

  • DAYS

  • DECODE

  • DEGREES

  • DO_TM_TASK

  • DROP_STATISTICS

  • EXP

  • FLOOR

  • GETDATE

  • GETUTCDATE

  • GREATEST

  • HASH

  • HEX_TO_BINARY

  • HOUR

  • IFNULL

  • INITCAP

  • INITCAPB

  • INSTR

  • ISDATE

  • ISNULL

  • ISNUMERIC

  • ISUTF8

  • JDE_TO_TIMESTAMP

  • LAST_DAY

  • LEAST

  • LEFT

  • LEN

  • LENGTH

  • LISTAGG

  • LN

  • LOCALTIME

  • LOCALTIMESTAMP

  • LOG

  • LOG10

  • LOWER

  • LOWERB

  • LPAD

  • LTRIM

  • MAX

  • MD5

  • MIN

  • MINUTE

  • MOD

  • MONTH

  • MONTHS_BETWEEN

  • NEXT_DAY

  • NEW_TIME

  • NOW

  • NULLIF

  • NULLIFZERO

  • NVL

  • NVL2

  • PI

  • POSITION

  • POSITIONB

  • POWER

  • POW

  • QUARTER

  • RADIANS

  • RANDOM

  • RANDOMINT

  • REFRESH

  • REGEXP_COUNT

  • REGEXP_LIKE

  • REGEXP_ILIKE

  • REGEXP_INSTR

  • REGEXP_NOT_ILIKE

  • REGEXP_NOT_LIKE

  • REGEXP_REPLACE

  • REGEXP_SUBSTR

  • REPLACE

  • REVERSE

  • RIGHT

  • ROUND

  • ROWIDTOCHAR

  • RTRIM

  • SECOND

  • SHA1

  • SHA224

  • SHA256

  • SHA384

  • SHA512

  • SIGN

  • SIN

  • SLEEP

  • SPACE

  • SPLIT_PART

  • SPLIT_PARTB

  • SQRT

  • START_REFRESH

  • STDDEV_POP

  • STDDEV_SAMP

  • STRINGHASH

  • STRPOS

  • STRPOSB

  • SUBSTR

  • SUBSTRING

  • SUM

  • TAN

  • THROW_ERROR

  • TIMEOFDAY

  • TIMESTAMPADD

  • TIMESTAMPDIFF

  • TIMESTAMP_ROUND

  • TIMESTAMP_TRUNC

  • TIME_SLICE

  • TO_CHAR

  • TO_DATE

  • TO_DAYS

  • TO_DECIMAL

  • TO_NUMBER

  • TO_TIME

  • TO_TIMESTAMP

  • TO_TIMESTAMP_TZ

  • TRANSLATE

  • TRIM

  • TRUNC

  • UPPER

  • UPPERB

  • WEEK

  • WEEK_ISO

  • YEAR

  • YEAR_ISO