Supported Spark SQL functions

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

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

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

• Spark SQL functions for creating a new measure

• Spark SQL functions for creating a new column

Spark SQL functions for creating a new measure

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

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

Spark SQL functions for creating a new column

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

And

IF

Not

OR

Switch

True and False

DATEDIFF

DAY

MONTH

TIME

YEAR

Len

Lower

Mid

Trim

Upper