Function Reference

Function Reference

The following N1QL functions are supported in Analytics:

Numeric Functions

ABS ACOS ASIN
ATAN ATAN2 CEIL
COS EXP FLOOR
LN LOG POWER
ROUND SIGN SIN
SQRT TAN TRUNC

String Functions

||, CONCAT (sugar) INITCAP LOWER
LTRIM RTRIM SUBSTR
TRIM UPPER LENGTH
REGEXP_POSITION CONTAINS POSITION
REPEAT TITLE SPLIT
REGEXP_CONTAINS REGEXP_LIKE REGXP_REPLACE

Comparison Functions

GREATEST (sugar) LEAST (sugar)

Environment and Identifier Functions

UUID (clone of create-uuid) META

Type Functions

ISARRAY ISBOOLEAN ISNUMBER ISOBJECT ISSTRING