...
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
...
Following is The table below presents a list of supported Spark SQL functions: ABS
ALL
ALLEXCEPT
ALLNOBLANKROW
ALLSELECTED
And
Blank
CALCULATE
CALCULATETABLE
CALENDAR
CALENDARAUTO
CEILING
CONTAINS
COUNT
COUNTA
COUNTAX
COUNTROWS
COUNTX
DATE
DATEDIFF
DATESBETWEEN
DATESINPERIOD
DATESMTD
DATESQTD
DATESYTD
DATEVALUE
DAY
DEGREES
DISTINCT
DISTINCTCOUNT
DIVIDE
ENDOFMONTH
ENDOFQUARTER
ENDOFYEAR
EVEN
EXP
Fact
FILTER
FILTERS
FIRSTDATE
FIRSTNONBLANK
Fixed
FLOOR
GCD
HASONEFILTER
HASONEVALUE
IF
IFERROR
INT
ISBLANK
ISBLANK
ISCROSSFILTERED
ISERROR
ISEVEN
ISFILTERED
ISLOGICAL
ISNONTEXT
ISNUMBER
ISO.CEILING
ISODD
ISTEXT
LASTDATE
LASTNONBLANK
LCM
Len
LN
LOG
LOG10
Lower
Mid
MOD
MONTH
MROUND
NEXTDAY
Not
NOW
ODD
OR
PI
POWER
PREVIOUSDAY
QUOTIENT
RADIANS
RAND
RANDBETWEEN
RELATEDTABLE
Round
ROUNDDOWN
ROUNDUP
SELECTEDVALUE
SIGN
SQRT
STARTOFMONTH
STARTOFQUARTER
STARTOFYEAR
SUMX
Switch
TIME
TODAY
TOTALMTD
TOTALQTD
TOTALYTD
Trim
True and False
TRUNC
Upper
USERNAME
VALUES
YEARSpark 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 |
|
|
ISFILTERED |
|
|
RELATEDTABLE |
|
|
SELECTEDVALUE |
|
|
VALUES |
|
|
COUNT |
|
|
COUNTA |
|
|
COUNTAX |
|
|
COUNTROWS |
|
|
COUNTX |
|
|
DISTINCTCOUNT |
|
|
DATE |
|
|
DATEDIFF |
|
|
DAY |
|
|
MONTH |
|
|
TIME |
|
|
YEAR |
|
|
Len |
|
|
Lower |
|
|
Mid |
|
|
Trim |
|
|
Upper |
|
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note The functions CALENDAR and CALENDARAUTO support creating a new table. |