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
    • Zookeeper
    • 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. release-1.5.1
  2. 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 Stream
NextQuerying Pinot

Last updated 9 days ago

Was this helpful?

Was this helpful?