Robuta

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