Apache Presto - Basic SQL Operations

VARCHAR

Variable length character data

BIGINT

A 64-bit signed integer

DOUBLE

A 64-bit floating point double precision value

DECIMAL

A fixed precision decimal number. For example DECIMAL(10,3) - 10 is precision, i.e. total number of digits and 3 is scale value represented as fractional point. Scale is optional and default value is 0

BOOLEAN

Boolean values true and false

VARBINARY

Variable length binary data

JSON

JSON data

DATE

Date data type represented as year-month-day

TIME, TIMESTAMP, TIMESTAMP with TIME ZONE

TIME - Time of the day (hour-min-sec-millisecond)

TIMESTAMP - Date and time of the day

TIMESTAMP with TIME ZONE - Date and time of the day with time zone from the value

INTERVAL

Stretch or extend date and time data types

ARRAY

Array of the given component type. For example, ARRAY[5,7]

MAP

Map between the given component types. For example, MAP(ARRAY[‘one’,’two’],ARRAY[5,7])

ROW

Row structure made up of named fields

Presto supports arithmetic operators such as +, -, *, /, %

<,>,<=,>=,=,<>

AND, OR, NOT

Range operator is used to test the value in a specific range. Presto supports BETWEEN, IS NULL, IS NOT NULL, GREATEST and LEAST

Binary arithmetic decimal operator performs binary arithmetic operation for decimal type Unary decimal operator − The - operator performs negation

The ‘||’ operator performs string concatenation

Performs arithmetic addition and subtraction operations on date and time data types

Subscript operator[] - access an element of an array

Concatenation operator || - concatenate an array with an array or an element of the same type

Map subscript operator [] - retrieve the value corresponding to a given key from a map