...
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
...
Following is The section presents a list of supported Spark SQL functions with information on whether they can be used for creating a measure, new column , or table.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note The functions CALENDAR and CALENDARAUTO support for creating a new table. |
Spark SQL functions for creating a new measure
| Anchor | ||||
|---|---|---|---|---|
|
The table below presents a list of Spark SQL functions for creating a 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
ISO.CEILING
ISODD
ISTEXT
TODAY
NOW
DATEVALUE
DATESBETWEEN
DATESINPERIOD
DATESMTD
DATESQTD
DATESYTD
ENDOFMONTH
ENDOFQUARTER
ENDOFYEAR
FIRSTDATE
FIRSTNONBLANK
LASTDATE
LASTNONBLANK
LCMNEXTDAY
PREVIOUSDAY
LenSTARTOFMONTHLN
STARTOFQUARTER
LOGSTARTOFYEARLOG10
TOTALMTD
LowerTOTALQTDMid
TOTALYTD
MODALL
MONTHALLEXCEPT
MROUNDALLNOBLANKROW
NEXTDAYALLSELECTED
NotCALCULATE
NOWCALCULATETABLE
ODDDISTINCT
ORFILTER
PIFILTERS
POWERHASONEFILTER
PREVIOUSDAYHASONEVALUE
QUOTIENTISCROSSFILTERED
RADIANSISFILTERED
RANDRELATEDTABLERANDBETWEEN
SELECTEDVALUE
RELATEDTABLEVALUESRound
COUNT
ROUNDDOWNCOUNTA
ROUNDUPCOUNTAX
SELECTEDVALUECOUNTROWS
SIGNCOUNTX
SQRTDISTINCTCOUNT
STARTOFMONTH
STARTOFQUARTER
STARTOFYEAR
SUMX
Switch
TIME
TODAY
TOTALMTD
TOTALQTD
TOTALYTD
TrimDATE
Spark SQL functions for creating a new column
| Anchor | ||||
|---|---|---|---|---|
|
The table below presents a list of Spark SQL functions for creating a new column.
And
IF
Not
OR
Switch
True and FalseTRUNC
DATEDIFF
UpperDAY
USERNAMEMONTH
VALUESTIME
YEAR
Len
Lower
Mid
Trim
Upper