Versions Compared

Old Version 4

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version 5

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 Column New Measure

New Table

Blank

 (error)

(tick)

(error)  

Len

(tick)

(error)

(error)

Lower

(tick)

(error)

(error)

Mid

(tick)

(error)

(error)

Trim

(tick)

(error)

(error)

Upper

(tick)

(error)

(error)

Fixed

 (error)

(tick)

(error)

Column

And

(tick)

(tick)

(error)

IF

(tick)

(tick)

(error)

Not

(tick)

(tick)(error)

OR

(tick)

(tick)

(error)

Switch

(tick)

(tick)

(error)

True and False

(tick)

(tick)

(error) Blank

IFERROR

(tick)

 (error)

(error)

ABS

(error) Fixed

(tick)

 (error)

CEILING

(error)

(tick)

(error)

EXP

(error)

(tick)

(error)

INT

(error)

(tick)

(error)

ISO.CEILING

(error)

(tick)

(error)

LOG10(error)

(tick)

(error)

MOD

(error)

(tick)

(error)

MROUND

(error)

(tick)

(error)

PI

(error)

(tick)

(error)

POWER

(error)

(tick)

(error)

QUOTIENT

(error)

(tick)

(error)

RAND(error)

(tick)

(error)

Round(error)

(tick)

(error)

ROUNDDOWN

(error)

(tick)

(error)

ROUNDUP(error)

(tick)

(error)

SIGN(error)

(tick)

(error)

SQRT(error)

(tick)

(error)

SUMX

(error)

(tick)

(error)

DEGREES

(error)

(tick)

(error)

DIVIDE(error)

(tick)

(error)

EVEN(error)

(tick)

(error)

Fact(error)

(tick)

(error)

FLOOR

(error)

(tick)

(error)

GCD

(error)

(tick)

(error)

LCM

(error)

(tick)

(error)

LN

(error)

(tick)

(error)

LOG(error)

(tick)

(error)

ODD(error)

(tick)

(error)

RADIANS

(error)

(tick)

(error)

RANDBETWEEN

(error)

(tick)

(error)

TRUNC

(error)

(tick)

(error)

ISBLANK

(error)

(tick)

(error)

ISBLANK

(error)

(tick)

(error)

USERNAME(error)

(tick)

(error)

CONTAINS

(error)

(tick)

(error)

ISERROR

(error)

(tick)

(error)

ISEVEN

(error)

(tick)

(error)

ISLOGICAL(error)

(tick)

(error)

ISNONTEXT

(error)

(tick)

(error)

ISNUMBER

(error)

(tick)

(error)

ISODD

(error)

(tick)

(error)

ISTEXT(error)

(tick)

(error)

TODAY(error)

(tick)

(error)

NOW(error)

(tick)

(error)

DATEVALUE

(error)

(tick)

(error)

DATESBETWEEN

(error)

(tick)

(error)

DATESINPERIOD

(error)

(tick)

(error)

DATESMTD

(error)

(tick)

(error)

DATESQTD(error)

(tick)

(error)

DATESYTD

(error)

(tick)

(error)

ENDOFMONTH

(error)

(tick)

(error)

ENDOFQUARTER

(error)

(tick)

(error)

ENDOFYEAR

(error)

(tick)

(error)

FIRSTDATE

(error)

(tick)

(error)

FIRSTNONBLANK(error)

(tick)

(error)

LASTDATE(error)

(tick)

(error)

LASTNONBLANK

(error)

(tick)

(error)

NEXTDAY(error)

(tick)

(error)

PREVIOUSDAY(error)

(tick)

(error)

STARTOFMONTH(error)

(tick)

(error)

STARTOFQUARTER

(error)

(tick)

(error)

STARTOFYEAR

(error)

(tick)

(error)

TOTALMTD(error)

(tick)

(error)

TOTALQTD(error)

(tick)

(error)

TOTALYTD(error)

(tick)

(error)

ALL

(error)

(tick)

(error)

ALLEXCEPT

(error)

(tick)

(error)

ALLNOBLANKROW

(error)

(tick)

(error)

ALLSELECTED

(error)

(tick)

(error)

CALCULATE(error)

(tick)

(error)

CALCULATETABLE(error)

(tick)

(error)

DISTINCT

(error)

(tick)

(error)

FILTER

(error)

(tick)

(error)

FILTERS

(error)

(tick)

(error)

HASONEFILTER

(error)

(tick)

(error)

HASONEVALUE

(error)

(tick)

(error)

ISCROSSFILTERED(error)

(tick)

(error)

ISFILTERED

(error)

(tick)

(error)

RELATEDTABLE(error)

(tick)

(error)

SELECTEDVALUE(error)

(tick)

(error)

VALUES(error)

(tick)

(error)

COUNT

(error)

(tick)

(error)

COUNTA

(error)

(tick)

(error)

COUNTAX

(error)

(tick)

(error)

COUNTROWS

(tick)

(error)

COUNTX

(tick)

(error)

DISTINCTCOUNT

COUNTX(tick)

(error)

DATE

(tick)

(error)

DISTINCTCOUNTDATEDIFF

(error)

(tick)

DAY

(error)

CALENDAR(tick)

(error) MONTH

 (error)

(tick)

CALENDARAUTOTIME

(error)  

(tick)

YEAR

(error)

(tick)

DATELen

(error)

(tick)

Lower

(error)

DATEDIFF

(tick)

(error) Mid

(error)DAY

(tick)

(error) Trim

(error)

MONTH(tick)(tick)

Upper

(error)

(tick) (error)

Panel

...

panelIconId

...

atlassian-note

...

panelIcon

...

:note:

...

bgColor

...

#DEEBFF

...

(error)

...

Note

The functions CALENDAR and CALENDARAUTO support creating a new table.