Spark SQL User Defined Functions

Seahorse uses Spark SQL as syntax for conditions, formulas and expressions in a few operations. Spark SQL allows execution of simple SQL or HiveQL queries.

This syntax has been enriched by registering User Defined Functions for usage in queries.


NOTE: The parser is case sensitive - function names have to be written in uppercase, column names parsing is also case sensitive.
NOTE: null values are propagated, e.g. the expression POW(SIN(score), 2.0) + 1.0 will return null for rows containing null values in score column.