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 section presents a list of Spark SQL functions with information on whether they can be used for creating a measure, new column , or table.
Note
The functions CALENDAR and CALENDARAUTO support for creating a new table.
The table below presents a list of Spark SQL functions for creating a new measure.
Spark SQL functions | New Measure |
|---|---|
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 |
|
ISFILTERED |
|
RELATEDTABLE |
|
SELECTEDVALUE |
|
VALUES |
|
COUNT |
|
COUNTA |
|
COUNTAX |
|
COUNTROWS |
|
COUNTX |
|
DISTINCTCOUNT |
|
DATE |
|
The table below presents a list of Spark SQL functions for creating a new column.
Spark SQL functions | New Column |
|---|---|
And |
|
IF |
|
Not |
|
OR |
|
Switch |
|
True and False |
|
DATEDIFF |
|
DAY |
|
MONTH |
|
TIME |
|
YEAR |
|
Len |
|
Lower |
|
Mid |
|
Trim |
|
Upper |
|