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 |
| |
Len |
|
|
Lower |
|
|
Mid |
|
|
Trim |
|
|
Upper |
|
|
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 |
|
|
ISFILTERED |
|
|
RELATEDTABLE |
|
|
SELECTEDVALUE |
|
|
VALUES |
|
|
COUNT |
|
|
COUNTA |
|
|
COUNTAX |
|
|
COUNTROWS |
|
|
COUNTX |
|
|
DISTINCTCOUNT |
|
|
CALENDAR | |
|
CALENDARAUTO | |
|
DATE |
|
|
DATEDIFF |
|
|
DAY |
|
|
MONTH |
|
|
TIME |
|
|
YEAR |
|
|
Note
The functions CALENDAR and CALENDARAUTO support creating a new table.