/
Supported Spark SQL functions

Supported Spark SQL functions

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

The table below presents a list of Spark SQL functions with information on whether they can be used for creating a new column, measure, or table.

Spark SQL functions

New Measure

New Column

Spark SQL functions

New Measure

New Column

And

IF

Not

OR

Switch

True and False

Blank

 

Fixed

 

ISO.CEILING

LOG10

MOD

MROUND

PI

POWER

QUOTIENT

RAND

Round

ROUNDDOWN

ROUNDUP

SIGN

SQRT

SUMX

DEGREES

DIVIDE

EVEN

Fact

FLOOR

GCD

LCM

LN

LOG

ODD

RADIANS

RANDBETWEEN

TRUNC

ISBLANK

ISBLANK

USERNAME

CONTAINS

ISERROR

ISEVEN

ISLOGICAL

ISNONTEXT

ISNUMBER

ISODD

ISTEXT

TODAY

NOW

DATEVALUE

DATESBETWEEN

DATESINPERIOD

DATESMTD

DATESQTD

DATESYTD

ENDOFMONTH

ENDOFQUARTER

ENDOFYEAR

FIRSTDATE

FIRSTNONBLANK

LASTDATE

LASTNONBLANK

NEXTDAY

PREVIOUSDAY

STARTOFMONTH

STARTOFQUARTER

STARTOFYEAR

TOTALMTD

TOTALQTD

TOTALYTD

ALL

ALLEXCEPT

ALLNOBLANKROW

ALLSELECTED

CALCULATE

CALCULATETABLE

DISTINCT

FILTER

FILTERS

HASONEFILTER

HASONEVALUE

ISCROSSFILTERED

Copyright Kyvos, Inc. 2026. All rights reserved.