Index of Functions and SQL Constructs Supported in Feldera SQL

• %: operators
• *: operators
• +: operators
• -: operators
• .: grammar
• /: operators
• ::: casts
• <: comparisons
• <=: comparisons
• <=>: operators
• <>: comparisons
• =: comparisons
• >: comparisons
• >=: comparisons
• ABS: decimal, float, integer, datetime
• ACOS: float
• ACOSH: float
• AND: boolean
• ARG_MAX (aggregate): aggregates
• ARG_MIN (aggregate): aggregates
• ARRAY (aggregate): aggregates
• ARRAY: array
• ARRAY_AGG (aggregate): aggregates
• ARRAY_APPEND: array
• ARRAY_COMPACT: array
• ARRAY_CONCAT: array
• ARRAY_CONTAINS: array
• ARRAY_DISTINCT: array
• ARRAY_EXCEPT: array
• ARRAY_EXISTS: array
• ARRAY_INSERT: array
• ARRAY_INTERSECT: array
• ARRAY_JOIN: array
• ARRAY_LENGTH: array
• ARRAY_MAX: array
• ARRAY_MIN: array
• ARRAY_POSITION: array
• ARRAY_PREPEND: array
• ARRAY_REMOVE: array
• ARRAY_REPEAT: array
• ARRAY_REVERSE: array
• ARRAY_SIZE: array
• ARRAY_TO_STRING: array
• ARRAY_UNION: array
• ARRAYS_OVERLAP: array
• AS: grammar
• ASCII: string
• ASIN: float
• ASINH: float
• ATAN: float
• ATAN2: float
• ATANH: float
• AVG (aggregate): aggregates, aggregates
• BETWEEN: comparisons, operators
• BIT_AND (aggregate): aggregates
• BIT_OR (aggregate): aggregates
• BIT_XOR (aggregate): aggregates
• BOOL_AND (aggregate): aggregates
• BOOL_OR (aggregate): aggregates
• BROUND: decimal
• CARDINALITY: array, map
• CASE: comparisons
• CAST: casts
• CBRT: float
• CEIL: decimal, float, datetime, datetime, datetime
• CHAR_LENGTH: string
• CHR: string
• COALESCE: comparisons
• CONCAT: string
• CONCAT_WS: string
• CONVERT: casts
• COS: float
• COSH: float
• COT: float
• COTH: float
• COUNT (aggregate): aggregates, aggregates, aggregates, aggregates
• COUNTIF (aggregate): aggregates
• CSC: float
• CSCH: float
• CUBE: grammar
• DATE: datetime
• DATE_ADD: datetime
• DATE_PART: datetime, datetime, datetime
• DATE_SUB: datetime
• DATE_TRUNC: datetime
• DATEDIFF: datetime, datetime
• DAYOFMONTH: datetime, datetime
• DEFAULT: grammar
• DEGREES: float
• DENSE_RANK (aggregate): aggregates
• DESC: grammar
• DOW: datetime, datetime
• DOY: datetime
• ELEMENT: array
• ESCAPE: string
• EVERY (aggregate): aggregates
• EXCEPT: grammar
• EXCEPT ALL: grammar
• EXISTS: comparisons
• EXP: float
• EXTRACT: datetime, datetime, datetime
• FILTER: aggregates
• FLOOR: decimal, float, datetime, datetime, datetime
• FORMAT_DATE: datetime
• GREATEST: comparisons
• GREATEST_IGNORE_NULLS: comparisons
• GROUPING: grammar
• GROUPING SETS: grammar
• GUNZIP: binary
• HOP: table
• HOUR: datetime, datetime, datetime
• IF: comparisons
• IFNULL: comparisons
• IGNORE NULLS: grammar
• ILIKE: string
• IN: comparisons
• INITCAP: string
• INITCAP_SPACES: string
• INTERSECT: grammar
• INTERVAL: datetime
• IS DISTINCT FROM: comparisons
• IS FALSE: operators
• IS NOT DISTINCT FROM: comparisons
• IS NOT FALSE: operators
• IS NOT NULL: comparisons, operators
• IS NOT TRUE: operators
• IS NOT UNKNOWN: operators
• IS NULL: comparisons, operators
• IS TRUE: operators
• IS UNKNOWN: operators
• IS_INF: float
• IS_NAN: float
• LAG (aggregate): aggregates
• LATERAL: grammar
• LEAD (aggregate): aggregates
• LEAST: comparisons
• LEAST_IGNORE_NULLS: comparisons
• LEFT: string, binary
• LEN: string
• LENGTH: string
• LIKE: string
• LN: float
• LOG: float
• LOG10: float
• LOGICAL_AND (aggregate): aggregates
• LOGICAL_OR (aggregate): aggregates
• LOWER: string
• MAP (aggregate): aggregates
• MAP: map
• MAP_CONTAINS_KEY: map
• MAX (aggregate): aggregates, aggregates
• MD5: string, binary
• MIN (aggregate): aggregates, aggregates
• MINUTE: datetime, datetime, datetime
• MOD: integer
• MONTH: datetime
• NOT: boolean
• NOT BETWEEN: comparisons
• NOT ILIKE: string
• NOT IN: comparisons
• NOT LIKE: string
• NOT RLIKE: string
• NOW: datetime
• NULLIF: comparisons
• NULLS FIRST: grammar
• NULLS LAST: grammar
• OCTET_LENGTH: binary
• OR: boolean
• OVER: grammar
• OVERLAPS: operators
• OVERLAY: string, binary
• PARSE_DATE: datetime
• PARSE_JSON: json
• PARSE_TIME: datetime
• PARSE_TIMESTAMP: datetime
• PI: float
• POSITION: string
• POWER: float
• QUARTER: datetime
• RADIANS: float
• RANK (aggregate): aggregates
• REGEXP_REPLACE: string
• REPEAT: string
• REPLACE: string
• RESPECT NULLS: grammar
• RIGHT: string, binary
• RLIKE: string
• RLIKE: string
• ROLLUP: grammar
• ROUND: float, float, decimal, decimal
• ROW: types
• ROW_NUMBER (aggregate): aggregates
• SAFE_CAST: casts
• SAFE_OFFSET: array
• SEC: float
• SECH: float
• SECOND: datetime, datetime, datetime
• SEQUENCE: integer
• SIGN: decimal
• SIN: float
• SINH: float
• SOME (aggregate): aggregates
• SORT_ARRAY: array
• SPLIT: string
• SPLIT_PART: string
• SQRT: float
• STDDEV (aggregate): aggregates
• STDDEV_POP (aggregate): aggregates
• STDDEV_SAMP (aggregate): aggregates
• SUBSTR: string
• SUBSTRING: string
• SUM (aggregate): aggregates, aggregates
• TABLE: table
• TAN: float
• TANH: float
• TIME: datetime
• TIME_TRUNC: datetime
• TIMESTAMP: datetime
• TIMESTAMP_TRUNC: datetime
• TIMESTAMPADD: datetime
• TIMESTAMPDIFF: datetime, datetime
• TO_HEX: binary
• TO_INT: binary
• TO_JSON: json
• TRANSFORM: array
• TRIM: string
• TRUNC: decimal, float
• TRUNCATE: decimal, decimal, float, float
• TUMBLE: table
• UNION: grammar
• UNION ALL: grammar
• UNNEST: array, map
• UPPER: string
• VALUES: grammar
• WEEK: datetime
• YEAR: datetime
• ||: string, binary