https://docs.pinot.apache.org/release-0.9.0/users/user-guide-query/json-queries
Querying JSON data | release-0.9.0 | Apache Pinot Docs
json dataapache pinotqueryingreleasedocs
https://docs.pinot.apache.org/release-0.4.0/basics/data-import/pinot-input-formats/import-from-avro
Import from Avro | release-0.4.0 | Apache Pinot Docs
This guide shows you how to import records into Pinot using Avro file format.
import fromapache pinotavroreleasedocs
https://docs.pinot.apache.org/release-1.4.0/for-operators/operating-pinot/consistent-push-and-rollback
Consistent Push and Rollback | Apache Pinot Docs
apache pinotconsistentpushrollbackdocs
https://docs.pinot.apache.org/release-1.1.0/for-operators/operating-pinot/instance-assignment
Instance Assignment | release-1.1.0 | Apache Pinot Docs
This page introduces all the instance assignment strategies, when to use them, and how to configure them.
apache pinotinstanceassignmentreleasedocs
https://docs.pinot.apache.org/release-1.4.0/functions-1/stcontains
ST_Contains | Apache Pinot Docs
This section contains reference documentation for the ST_Contains function.
apache pinotstcontainsdocs
https://docs.pinot.apache.org/release-1.3.0/for-developers/developers-and-contributors/extending-pinot/segment-fetchers
Segment Fetchers | release-1.3.0 | Apache Pinot Docs
apache pinotsegmentreleasedocs
https://docs.pinot.apache.org/release-1.1.0/basics/data-import/pinot-input-formats/schema-conforming-transformer
Ingest records with dynamic schemas | release-1.1.0 | Apache Pinot Docs
Storing records with dynamic schemas in a table with a fixed schema.
apache pinotingestrecordsdynamicschemas
https://docs.pinot.apache.org/release-1.2.0/configuration-reference/functions/funnelmaxstep-1
FunnelMaxStep | release-1.2.0 | Apache Pinot Docs
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.2.0/configuration-reference/functions/regexpextract
regexpExtract | release-1.2.0 | Apache Pinot Docs
This section contains reference documentation for the regexpExtract function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.0.0/for-users/user-guide-query/supported-transformations
Transformation Functions | release-1.0.0 | Apache Pinot Docs
This document contains the list of all the transformation functions supported by Pinot SQL.
apache pinottransformationfunctionsreleasedocs
https://docs.pinot.apache.org/release-0.11.0/basics/indexing/json-index
JSON Index | release-0.11.0 | Apache Pinot Docs
apache pinotjsonindexreleasedocs
https://docs.pinot.apache.org/release-1.4.0/basics/getting-started/public-cloud-examples/aws-quickstart
Running on AWS | Apache Pinot Docs
This quickstart guide helps you get started running Pinot on Amazon Web Services (AWS).
running on awsapache pinotdocs
https://docs.pinot.apache.org/release-1.3.0/configuration-reference/functions/stpolygon
ST_Polygon | release-1.3.0 | Apache Pinot Docs
This section contains reference documentation for the ST_Polygon function.
apache pinotstpolygonreleasedocs
https://docs.pinot.apache.org/release-1.0.0/for-developers/developers-and-contributors/extending-pinot/custom-aggregation-function
Writing Custom Aggregation Function | release-1.0.0 | Apache Pinot Docs
apache pinotwritingcustomaggregationfunction
https://docs.pinot.apache.org/release-1.2.0/for-users/api
APIs | release-1.2.0 | Apache Pinot Docs
apache pinotapisreleasedocs
https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stpoint
STPOINT | release-1.1.0 | Apache Pinot Docs
This section contains reference documentation for the ST_POINT/STPOINT function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.1.0/resources/community
Community | release-1.1.0 | Apache Pinot Docs
apache pinotcommunityreleasedocs
https://docs.pinot.apache.org/release-1.2.0/basics/recipes/redash
Visualize data with Redash | release-1.2.0 | Apache Pinot Docs
visualize dataapache pinotredashrelease
https://docs.pinot.apache.org/release-0.4.0/basics/components/segment
Segment | release-0.4.0 | Apache Pinot Docs
apache pinotsegmentreleasedocs
https://docs.pinot.apache.org/release-1.4.0/for-users/user-guide-query/multi-stage-query/multistage-lite-mode
Multistage Lite Mode | Apache Pinot Docs
Introduces the Multistage Engine Lite Mode
lite modeapache pinotmultistagedocs
https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/sum
sum | release-1.1.0 | Apache Pinot Docs
This section contains reference documentation for the sum function.
apache pinotsumreleasedocs
https://docs.pinot.apache.org/release-1.2.0/basics/data-import/segment-compaction-on-upserts
Segment compaction on upserts | release-1.2.0 | Apache Pinot Docs
Use segment compaction on upsert-enabled real-time tables.
apache pinotsegmentcompactionrelease
https://docs.pinot.apache.org/release-1.3.0/configuration-reference/functions/jsonpath
JSONPATH | release-1.3.0 | Apache Pinot Docs
This section contains reference documentation for the JSONPATH function.
apache pinotjsonpathreleasedocs
https://docs.pinot.apache.org/release-0.12.0/basics/components/tenant
Tenant | release-0.12.0 | Apache Pinot Docs
apache pinottenantreleasedocs
https://docs.pinot.apache.org/release-0.4.0/integrations/superset
Superset | release-0.4.0 | Apache Pinot Docs
Integrate with Superset
apache pinotsupersetreleasedocs
https://docs.pinot.apache.org/release-1.4.0/basics/concepts/components/table/segment/segment-retention
Segment retention | Apache Pinot Docs
In this Apache Pinot concepts guide, we'll learn how segment retention works.
apache pinotsegmentretentiondocs
https://docs.pinot.apache.org/release-1.3.0/configuration-reference/functions/distinctcountull
DISTINCTCOUNTULL | release-1.3.0 | Apache Pinot Docs
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.2.0/configuration-reference/functions/regexpreplace
regexpReplace | release-1.2.0 | Apache Pinot Docs
This section contains reference documentation for the regexpReplace function
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.3.0/basics/data-import/pinot-file-system/import-from-adls-azure
Azure Data Lake Storage | release-1.3.0 | Apache Pinot Docs
This guide shows you how to import data from files stored in Azure Data Lake Storage Gen2 (ADLS Gen2)
azure data lake storageapache pinotrelease
https://docs.pinot.apache.org/release-1.2.0/basics/releases/0.5.0
0.5.0 | release-1.2.0 | Apache Pinot Docs
This release includes many new features on Pinot ingestion and connectors, query capability and a revamped controller UI.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.0.0/configuration-reference/functions/sqrt
sqrt | release-1.0.0 | Apache Pinot Docs
This section contains reference documentation for the sqrt function.
apache pinotsqrtreleasedocs
https://docs.pinot.apache.org/release-1.3.0/basics/releases/0.9.0
0.9.0 | release-1.3.0 | Apache Pinot Docs
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.2.0/for-operators/tutorials/build-docker-images
Build Docker Images | release-1.2.0 | Apache Pinot Docs
docker imagesapache pinotbuildreleasedocs
https://docs.pinot.apache.org/release-0.12.0/configuration-reference/functions/substr
substr | release-0.12.0 | Apache Pinot Docs
This section contains reference documentation for the substr function.
apache pinotsubstrreleasedocs
https://docs.pinot.apache.org/release-0.10.0/configuration-reference/functions/percentileestmv
percentileestmv | release-0.10.0 | Apache Pinot Docs
This section contains reference documentation for the PERCENTILEESTMV function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-0.10.0/configuration-reference/functions/distinctcounthllmv
DISTINCTCOUNTHLLMV | release-0.10.0 | Apache Pinot Docs
This section contains reference documentation for the DISTINCTCOUNTBITMAPMV function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-0.10.0/configuration-reference/functions/replace
replace | release-0.10.0 | Apache Pinot Docs
This section contains reference documentation for the REPLACE function.
apache pinotreplacereleasedocs
https://docs.pinot.apache.org/release-1.4.0/functions-1/toepochbucket
ToEpochBucket | Apache Pinot Docs
This section contains reference documentation for the toEpochBucket functions.
apache pinotdocs
https://docs.pinot.apache.org/release-1.4.0/functions-1/distinct_count_off_heap
DISTINCT_COUNT_OFF_HEAP | Apache Pinot Docs
This section contains reference documentation for the DISTINCT_COUNT_OFF_HEAP function.
apache pinotdistinctcountheapdocs
https://docs.pinot.apache.org/release-0.12.1/configuration-reference/functions/rpad
rpad | release-0.12.1 | Apache Pinot Docs
This section contains reference documentation for the RPAD function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.4.0/for-users/api/querying-pinot-using-standard-sql
Broker Query API | Apache Pinot Docs
query apiapache pinotbrokerdocs
https://docs.pinot.apache.org/release-1.2.0/configuration-reference/functions/distinctcountrawhll
DISTINCTCOUNTRAWHLL | release-1.2.0 | Apache Pinot Docs
This section contains reference documentation for the DISTINCTCOUNTRAWHLL function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.2.0/configuration-reference/functions/timezoneminute
timezoneMinute | release-1.2.0 | Apache Pinot Docs
This section contains reference documentation for the timezoneMinute function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.4.0/functions-1/dayofyear
dayOfYear | Apache Pinot Docs
This section contains reference documentation for the dayOfYear function.
apache pinotdocs
https://docs.pinot.apache.org/release-0.12.1/integrations/trino
Trino | release-0.12.1 | Apache Pinot Docs
Integrate with Trino for ad-hoc queries with Full SQL
apache pinottrinoreleasedocs
https://docs.pinot.apache.org/functions/function-index
Function Index | Apache Pinot Docs
function indexapache pinotdocs
https://docs.pinot.apache.org/release-1.2.0/for-developers/design-documents
Design Documents | release-1.2.0 | Apache Pinot Docs
Links to all the design docs
design documentsapache pinotreleasedocs
https://docs.pinot.apache.org/release-0.12.1/operators/operating-pinot/instance-assignment
Instance Assignment | release-0.12.1 | Apache Pinot Docs
This page introduces all the instance assignment strategies, when to use them, and how to configure them
apache pinotinstanceassignmentreleasedocs
https://docs.pinot.apache.org/release-1.4.0/for-operators/tutorials
Tutorials | Apache Pinot Docs
Here you will find a collection of how-to guides for operators or developers
apache pinottutorialsdocs
https://docs.pinot.apache.org/release-0.12.0/configuration-reference/functions/trim
trim | release-0.12.0 | Apache Pinot Docs
This section contains reference documentation for the trim function.
apache pinottrimreleasedocs
https://docs.pinot.apache.org/release-1.4.0/basics/indexing/inverted-index
Inverted index | Apache Pinot Docs
This page describes configuring the inverted index for Apache Pinot
apache pinotinvertedindexdocs
https://docs.pinot.apache.org/release-0.12.1/basics/getting-started/frequent-questions/operations-faq
Operations FAQ | release-0.12.1 | Apache Pinot Docs
apache pinotoperationsfaqreleasedocs
https://docs.pinot.apache.org/release-0.12.0/users/tutorials/batch-data-ingestion-in-practice
Batch Data Ingestion In Practice | release-0.12.0 | Apache Pinot Docs
data ingestionapache pinotbatchpractice
https://docs.pinot.apache.org/release-1.0.0/for-developers/advanced/data-ingestion
Data Ingestion Overview | release-1.0.0 | Apache Pinot Docs
data ingestionapache pinotoverviewreleasedocs
https://docs.pinot.apache.org/release-1.4.0/functions-1/jsonpatharraydefaultempty
JSONPATHARRAYDEFAULTEMPTY | Apache Pinot Docs
This section contains reference documentation for the JSONPATHARRAYDEFAULTEMPTY function.
apache pinotdocs
https://docs.pinot.apache.org/release-1.1.0/basics/data-import/batch-ingestion/spark
Spark | release-1.1.0 | Apache Pinot Docs
Batch ingestion of data into Apache Pinot using Apache Spark.
apache pinotsparkreleasedocs
https://docs.pinot.apache.org/release-1.2.0/for-operators/operating-pinot/consistent-push-and-rollback
Consistent Push and Rollback | release-1.2.0 | Apache Pinot Docs
apache pinotconsistentpushrollbackrelease
https://docs.pinot.apache.org/release-1.4.0/for-users/user-guide-query/multi-stage-query/optimizing-joins
Optimizing joins | Apache Pinot Docs
Tips and tricks that can be used to optimize joins
apache pinotoptimizingjoinsdocs
https://docs.pinot.apache.org/release-0.4.0/users/api/querying-pinot-using-standard-sql/response-format
Response Format | release-0.4.0 | Apache Pinot Docs
response formatapache pinotreleasedocs
https://docs.pinot.apache.org/release-1.4.0/functions-1/jsonpathlong
JSONPATHLONG | Apache Pinot Docs
This section contains reference documentation for the JSONPATHLONG function.
apache pinotdocs
https://docs.pinot.apache.org/release-0.11.0/configuration-reference/functions/now
now | release-0.11.0 | Apache Pinot Docs
This section contains reference documentation for the now function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.1.0/basics/components/table/schema
Schema | release-1.1.0 | Apache Pinot Docs
Explore the Schema component in Apache Pinot, vital for defining the structure and data types of Pinot tables, enabling efficient data processing and analysis.
apache pinotschemareleasedocs
https://docs.pinot.apache.org/architecture-and-concepts/components/cluster/controller
Controller | Apache Pinot Docs
Discover the controller component of Apache Pinot, enabling efficient data and query management.
apache pinotcontrollerdocs
https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/extract
Extract | release-1.1.0 | Apache Pinot Docs
This section contains reference documentation for the Extract function.
apache pinotextractreleasedocs
https://docs.pinot.apache.org/release-1.0.0/basics/concepts
Concepts | release-1.0.0 | Apache Pinot Docs
Explore the fundamental concepts of Apache Pinot for efficient data processing and analysis. Gain insights into the core principles and foundational ideas...
apache pinotconceptsreleasedocs
https://advisories.gitlab.com/maven/org.apache.pinot/pinot-broker/CVE-2024-56325/
Apache Pinot Vulnerable to Authentication Bypass | GitLab Advisory Database (GLAD)
CVE-2024-56325 Apache Pinot Vulnerable to Authentication Bypass: Authentication Bypass Issue If the path does not contain / and contain., authentication is not...
apache pinotauthentication bypassvulnerablegitlabadvisory
https://docs.pinot.apache.org/release-1.4.0/functions-1/rtrim
rtrim | Apache Pinot Docs
This section contains reference documentation for the rtrim function.
apache pinotdocs
https://docs.pinot.apache.org/release-1.2.0/basics/releases/0.9.3
0.9.3 | release-1.2.0 | Apache Pinot Docs
apache pinotreleasedocs
https://startree.ai/resources/reduce-the-cost-of-real-time-upserts-in-apache-pinot-by-10x-with-startree/
Reduce the Cost of Upserts in Apache Pinot by 10x | StarTree
Sep 9, 2025 - Learn how StarTree Cloud overcomes the limitations of real-time upserts in Apache Pinot to increase scalability and reduce costs by 10x.
the cost ofapache pinotreduce
https://docs.pinot.apache.org/release-1.4.0/functions-1/percentilemv
percentilemv | Apache Pinot Docs
This section contains reference documentation for the PERCENTILEMV function.
apache pinotdocs
https://docs.pinot.apache.org/release-1.2.0/configuration-reference/functions/arraydistinctstring
arrayDistinctString | release-1.2.0 | Apache Pinot Docs
This section contains reference documentation for the arrayDistinctString function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-0.11.0/basics/getting-started/public-cloud-examples/azure-quickstart
Running on Azure | release-0.11.0 | Apache Pinot Docs
This starter guide provides a quick start for running Pinot on Microsoft Azure
on azureapache pinotrunningreleasedocs
https://docs.pinot.apache.org/release-0.9.0/integrations/superset?fallback=true
Superset | release-0.9.0 | Apache Pinot Docs
Integrate with Superset
apache pinotsupersetreleasedocs
https://docs.pinot.apache.org/release-1.3.0/basics/getting-started/pushing-your-data-to-pinot
Batch import example | release-1.3.0 | Apache Pinot Docs
Step-by-step guide for pushing your own data into the Pinot cluster
apache pinotbatchimportexamplerelease
https://docs.pinot.apache.org/release-0.12.1/configuration-reference/functions/ln
ln | release-0.12.1 | Apache Pinot Docs
This section contains reference documentation for the ln function.
apache pinotlnreleasedocs
https://docs.pinot.apache.org/release-1.2.0/configuration-reference/functions/reverse
reverse | release-1.2.0 | Apache Pinot Docs
This section contains reference documentation for the reverse function.
apache pinotreversereleasedocs
https://docs.pinot.apache.org/release-1.0.0/configuration-reference/functions/sha
sha | release-1.0.0 | Apache Pinot Docs
This section contains reference documentation for the SHA function.
apache pinotshareleasedocs
https://docs.pinot.apache.org/release-1.4.0/for-operators/cli
Command-Line Interface (CLI) | Apache Pinot Docs
command line interfaceapache pinotclidocs
https://docs.pinot.apache.org/release-1.0.0/reference/cluster
Single-stage query engine (v1) | release-1.0.0 | Apache Pinot Docs
An overview of the single-stage query engine.
single stagequery engineapache pinot
https://docs.pinot.apache.org/release-1.2.0/basics/indexing/text-search-support
Text search support | release-1.2.0 | Apache Pinot Docs
This page talks about support for text search in Pinot.
text searchapache pinotsupportreleasedocs
https://docs.pinot.apache.org/release-1.2.0/basics/concepts/components/cluster
Cluster | release-1.2.0 | Apache Pinot Docs
Learn to build and manage Apache Pinot clusters, uncovering key components for efficient data processing and optimized analysis.
apache pinotclusterreleasedocs
https://docs.pinot.apache.org/release-1.4.0/functions-1/timezoneminute
timezoneMinute | Apache Pinot Docs
This section contains reference documentation for the timezoneMinute function.
apache pinotdocs
https://docs.pinot.apache.org/release-0.11.0/integrations/tableau
Tableau | release-0.11.0 | Apache Pinot Docs
This section details how to connect to Pinot from Tableau using JDBC
apache pinottableaureleasedocs
https://docs.pinot.apache.org/release-1.0.0/configuration-reference/functions/datetrunc
DATETRUNC | release-1.0.0 | Apache Pinot Docs
This section contains reference documentation for the DATETRUNC function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-0.11.0/configuration-reference/functions/arrayconcatfloat
arrayConcatFloat | release-0.11.0 | Apache Pinot Docs
This section contains reference documentation for the arrayConcatFloat function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-1.4.0/basics/releases/0.9.2
0.9.2 | Apache Pinot Docs
apache pinotdocs
https://docs.pinot.apache.org/release-1.1.0/basics/data-import/clp
Stream Ingestion with CLP | release-1.1.0 | Apache Pinot Docs
Support for encoding fields with CLP during ingestion.
apache pinotstreamingestionclprelease
https://docs.pinot.apache.org/release-1.3.0
Introduction | release-1.3.0 | Apache Pinot Docs
Apache Pinot is a real-time distributed OLAP datastore purpose-built for low-latency, high-throughput analytics, and perfect for user-facing analytical...
apache pinotintroductionreleasedocs
https://docs.pinot.apache.org/release-1.1.0/for-operators/operating-pinot/separating-data-storage-by-age/using-multiple-directories
Using multiple directories | release-1.1.0 | Apache Pinot Docs
multiple directoriesapache pinotusingreleasedocs
https://docs.pinot.apache.org/release-0.4.0/users/clients/golang
Golang | release-0.4.0 | Apache Pinot Docs
Pinot Client for Golang
apache pinotgolangreleasedocs
https://docs.pinot.apache.org/release-1.0.0/configuration-reference/functions/second
second | release-1.0.0 | Apache Pinot Docs
This section contains reference documentation for the second function.
apache pinotsecondreleasedocs
https://docs.pinot.apache.org/release-1.4.0/functions-1/firstwithtime
FIRSTWITHTIME | Apache Pinot Docs
This section contains reference documentation for the firstwithtime function.
apache pinotdocs
https://docs.pinot.apache.org/release-0.10.0/configuration-reference/functions/maxmv?fallback=true
MAXMV | release-0.10.0 | Apache Pinot Docs
This section contains reference documentation for the MAXMV function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-0.10.0/configuration-reference/functions/md5
MD5 | release-0.10.0 | Apache Pinot Docs
This section contains reference documentation for the MD5 function.
apache pinotreleasedocs
https://docs.pinot.apache.org/release-0.12.1/basics/components/minion
Minion | release-0.12.1 | Apache Pinot Docs
apache pinotminionreleasedocs
https://docs.pinot.apache.org/release-1.0.0/basics/components/cluster/controller
Controller | release-1.0.0 | Apache Pinot Docs
Discover the controller component of Apache Pinot, enabling efficient data and query management.
apache pinotcontrollerreleasedocs
https://docs.pinot.apache.org/release-0.11.0/configuration-reference/functions/codepoint
codepoint | release-0.11.0 | Apache Pinot Docs
This section contains reference documentation for the CODEPOINT function.
apache pinotcodepointreleasedocs
https://docs.pinot.apache.org/release-0.12.0/developers/plugin-architecture/write-custom-plugins/write-your-batch
Batch Segment Fetcher Plugin | release-0.12.0 | Apache Pinot Docs
apache pinotbatchsegmentfetcherplugin
https://docs.pinot.apache.org/release-0.4.0/developers/tutorials/pinot-connectors/streaming/kafka
Kafka | release-0.4.0 | Apache Pinot Docs
This page describes how to connect Kafka to Pinot
apache pinotkafkareleasedocs
https://docs.pinot.apache.org/release-1.2.0/configuration-reference/functions/add?fallback=true
ADD | release-1.2.0 | Apache Pinot Docs
This section contains reference documentation for the ADD function.
apache pinotaddreleasedocs