Versions Compared

Old Version 6

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version 7

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

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

...

(tick) Kyvos Azure Marketplace   (tick) Kyvos GCP Marketplace (tick) Kyvos Single Node Installation (Kyvos SNI)

...

The table below section presents a list of Spark SQL functions with information on whether they can be used for creating a measure, new column , measure, or table.or table.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

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.

Anchor
measure
measure

Note

...

Spark SQL functions

New Measure

New Column

And

(tick)

(tick)

IF

(tick)

(tick)

Not

(tick)

(tick)

OR

(tick)

(tick)

Switch

(tick)

(tick)

True and False

(tick)

(tick)

Blank

(tick)

 (error)

Fixed

(tick)

 (error)

ISO.CEILING

(tick)

(error)

LOG10

(tick)

(error)

MOD

(tick)

(error)

MROUND

(tick)

(error)

PI

(tick)

(error)

POWER

(tick)

(error)

QUOTIENT

(tick)

(error)

RAND

(tick)

(error)

Round

(tick)

(error)

ROUNDDOWN

(tick)

(error)

ROUNDUP

(tick)

(error)

SIGN

(tick)

(error)

SQRT

(tick)

(error)

SUMX

(tick)

(error)

DEGREES

(tick)

(error)

DIVIDE

(tick)

(error)

EVEN

(tick)

(error)

Fact

(tick)

(error)

FLOOR

(tick)

(error)

GCD

(tick)

(error)

LCM

(tick)

(error)

LN

(tick)

(error)

LOG

(tick)

(error)

ODD

(tick)

(error)

RADIANS

(tick)

(error)

RANDBETWEEN

(tick)

(error)

TRUNC

(tick)

(error)

ISBLANK

(tick)

(error)

ISBLANK

(tick)

(error)

USERNAME

(tick)

(error)

CONTAINS

(tick)

(error)

ISERROR

(tick)

(error)

ISEVEN

(tick)

(error)

ISLOGICAL

(tick)

(error)

ISNONTEXT

(tick)

(error)

ISNUMBER

(tick)

(error)

ISODD

(tick)

(error)

ISTEXT

(tick)

(error)

TODAY

(tick)

(error)

NOW

(tick)

(error)

DATEVALUE

(tick)

(error)

DATESBETWEEN

(tick)

(error)

DATESINPERIOD

(tick)

(error)

DATESMTD

(tick)

(error)

DATESQTD

(tick)

(error)

DATESYTD

(tick)

(error)

ENDOFMONTH

(tick)

(error)

ENDOFQUARTER

(tick)

(error)

ENDOFYEAR

(tick)

(error)

FIRSTDATE

(tick)

(error)

FIRSTNONBLANK

(tick)

(error)

LASTDATE

(tick)

(error)

LASTNONBLANK

(tick)

(error)

NEXTDAY

(tick)

(error)

PREVIOUSDAY

(tick)

(error)

STARTOFMONTH

(tick)

(error)

STARTOFQUARTER

(tick)

(error)

STARTOFYEAR

(tick)

(error)

TOTALMTD

(tick)

(error)

TOTALQTD

(tick)

(error)

TOTALYTD

(tick)

(error)

ALL

(tick)

(error)

ALLEXCEPT

(tick)

(error)

ALLNOBLANKROW

(tick)

(error)

ALLSELECTED

(tick)

(error)

CALCULATE

(tick)

(error)

CALCULATETABLE

(tick)

(error)

DISTINCT

(tick)

(error)

FILTER

(tick)

(error)

FILTERS

(tick)

(error)

HASONEFILTER

(tick)

(error)

HASONEVALUE

(tick)

(error)

ISCROSSFILTERED

(tick)

(error)

ISFILTERED

(tick)

(error)

RELATEDTABLE

(tick)

(error)

SELECTEDVALUE

(tick)

(error)

VALUES

(tick)

(error)

COUNT

(tick)

(error)

COUNTA

(tick)

(error)

COUNTAX

(tick)

(error)

COUNTROWS

(tick)

(error)

COUNTX

(tick)

(error)

DISTINCTCOUNT

(tick)

(error)

DATE

(tick)

(error)

DATEDIFF

(error)

(tick)

DAY

(error)

(tick)

MONTH

(error)

(tick)

TIME

(error)

(tick)

YEAR

(error)

(tick)

Len

(error)

(tick)

Lower

(error)

(tick)

Mid

(error)

(tick)

Trim

(error)

(tick)

Upper

(error)

(tick)

...

panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

The table below presents a list of Spark SQL functions for creating a new column.

Anchor
column
column

Spark SQL functions

New Column

And

(tick)

IF

(tick)

Not

(tick)

OR

(tick)

Switch

(tick)

True and False

(tick)

DATEDIFF

(tick)

DAY

(tick)

MONTH

(tick)

TIME

(tick)

YEAR

(tick)

Len

(tick)

Lower

(tick)

Mid

(tick)

Trim

(tick)

Upper

(tick)