Transformation Functions

This document contains the list of all the transformation functions supported by Pinot SQL.

Math Functions

Function

String Functions

Multiple string functions are supported out of the box from release-0.5.0 .

Function

DateTime Functions

Date time functions allow you to perform transformations on columns that contain timestamps or dates.

Function

JSON Functions

Transform Functions

These functions can only be used in Pinot SQL queries.

Function

Scalar Functions

These functions can be used for column transformation in table ingestion configs.

Function

Binary Functions

Function

Multi-value Column Functions

All of the functions mentioned till now only support single value columns. You can use the following functions to do operations on multi-value columns.

Function

MAP_VALUE Select the value for a key from Map stored in Pinot. MAP_VALUE(mapColumn, 'myKey', valueColumn)

Advanced Queries

Geospatial Queries

Text Queries

Last updated

Was this helpful?