release-1.0.0

latest release-1.2.0 release-1.1.0 release-1.0.0 release-0.12.1 release-0.12.0 release-0.11.0 release-0.10.0 release-0.9.0 release-0.4.0

release-1.0.0

latest release-1.2.0 release-1.1.0 release-1.0.0 release-0.12.1 release-0.12.0 release-0.11.0 release-0.10.0 release-0.9.0 release-0.4.0

Introduction
Basics
For Users
For Developers
For Operators
Configuration Reference
Reference
- Single-stage query engine (v1)
- Multi-stage query engine (v2)
RESOURCES
Integrations
Contributing
- Contribute Pinot documentation
- Style guide

Powered by GitBook

On this page

Was this helpful?

Configuration Reference

Functions

This page contains reference documentation for functions in Apache Pinot.

PreviousMonitoring Metrics NextABS

Was this helpful?

This page contains reference documentation for functions in Apache Pinot.

https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/timezoneHour.md

https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/timezoneMinute.md

https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpoch.md

https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpochBucket.md

https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpochRounded.md

https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/yearOfWeek.md

arrayConcatDouble

arrayConcatFloat

arrayConcatLong

arrayConcatString

arrayContainsInt

arrayContainsString

arrayDistinctInt

arrayDistinctString

arrayIndexOfInt

arrayIndexOfString

arrayRemoveString

arrayReverseInt

arrayReverseString

arraySliceString

arraySortString

arrayUnionString

DATETIMECONVERT

DISTINCTCOUNTBITMAP

DISTINCTCOUNTHLLMV

DISTINCTCOUNTHLL

DISTINCTCOUNTBITMAPMV

DISTINCTCOUNTMV

DISTINCTCOUNTRAWHLL

DISTINCTCOUNTRAWHLLMV

DISTINCTCOUNTRAWTHETASKETCH

DISTINCTCOUNTTHETASKETCH

FromEpochBucket

jsonextractscalar

JSONPATHARRAYDEFAULTEMPTY

percentileestmv

percentiletdigest

percentiletdigestmv

percentilerawkll

percentilekllmv

percentilerawkllmv

SEGMENTPARTITIONEDDISTINCTCOUNT

ST_GeogFromText

ST_GeometryType

ST_GeomFromText

toSphericalGeography

ROW_NUMBERlatest