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 |
|---|---|---|
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 |
|