LogoLogo
⌘Ctrlk
LogoLogo
  • Introduction
    • Concepts
    • Getting Started
    • Indexing
    • Release notes
    • Recipes
    • Query
      • Querying Pinot
      • Query Syntax
      • Multi-stage query
      • Time Series Queries
      • Query Options
      • Query Quotas
      • Query Cancellation
      • Query Correlation ID
      • Query using Cursors
    • APIs
    • External Clients
    • Tutorials
    • Basics
    • Advanced
    • Plugins
    • Design Documents
    • Deployment and Monitoring
    • Command-Line Interface (CLI)
    • Configuration Recommendation Engine
    • Tutorials
    • Cluster
    • Controller
    • Broker
    • Server
    • Table
    • Ingestion
    • Schema
    • Database
    • Ingestion Job Spec
    • Monitoring Metrics
    • Plugin Reference
    • Dynamic Environment
    • Import Data
    • Aggregation Functions
    • Transformation Functions
    • Array Functions
    • Binary Functions
    • DateTime Functions
    • Funnel Analysis Functions
    • GeoSpatial Functions
    • Hash Functions
    • JSON Functions
    • Math Functions
    • String Functions
    • User-Defined Functions (UDFs)
    • URL Functions
    • Unique Count and cardinality Estimation Functions
  • Window Functions
  • Function List
    • Single-stage query engine (v1)
    • Multi-stage query engine (v2)
    • Troubleshooting
    • Community
    • Team
    • Blogs
    • Presentations
    • Videos
    • Tableau
    • Trino
    • ThirdEye
    • Superset
    • Presto
    • Spark-Pinot Connector
    • Metabase
    • Contribute Pinot documentation
    • Style guide
Powered by GitBook
For the complete documentation index, see llms.txt. This page is also available as Markdown.
  1. For Users

Query

Learn how to query Apache Pinot using SQL or explore data using the web-based Pinot query console.

Pinot Query Console
Querying PinotQuery OptionsQuery Quotas

Explore query syntax:

JSON FunctionsAggregation FunctionsUnique Count and cardinality Estimation FunctionsExplain Plan (Single-Stage)Filtering with IdSetGapFill Function For Time-Series DatasetGrouping AlgorithmJOINsJOINsLookup UDF JoinTransformation FunctionsUser-Defined Functions (UDFs)Window FunctionsWindow Functions
PreviousGitHub Events StreamNextQuerying Pinot

Was this helpful?

Was this helpful?