Versions Compared

Old Version 3

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version 4

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)

IFERRORBlank

(tick)

 (error)

Len

(error)

ABS(tick)

Lower

(error)

(tick)

(error) Mid

CEILING

(error)

(tick)

(error) Trim

EXP

(error)

(tick)

Upper

(error)

INT(tick)

(error) Fixed

(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(error)

(tick)

(error)

COUNTX

(error)

(tick)

(error)

DISTINCTCOUNT

(error)

(tick)

(error)

CALENDAR

 (error)  

(error)

(tick)

CALENDARAUTO

 (error)  

(error)

DATE

(tick)

(error)

DATEDATEDIFF

(error)

(tick)

DAY

(error)DATEDIFF

(tick)

(error) MONTH

(error)

DAY

(tick)

(error) TIME

(error)

MONTH(tick)(tick)

YEAR

(error) (error)

(tick)

Panel

...

panelIconId

...

atlassian-note

...

panelIcon

...

:note:

...

bgColor

...

#DEEBFF

...

(error)

...

Note

The functions CALENDAR and CALENDARAUTO support creating a new table.