Querying & SQL

Learn how to query Apache Pinot, choose the right query engine, and find SQL and function guidance quickly.

Use this section to decide how to query Pinot, how much SQL support you need, which query engine to use, and where to look for execution controls such as quotas, cancellation, and cursors. Narrative guidance lives here. Dense syntax and endpoint detail is linked where needed.

Start here

Querying PinotSQL syntaxSQL DDLMaterialized ViewsOverviewQuery Engines (SSE vs MSE)Query options, quotas, cancellation & cursors

Deep dives

For explain plans, joins, optimizer behavior, and operator details, continue into the multi-stage query docs and engine-specific material linked from SSE vs MSE and SQL syntax.

What this page covered

This page mapped the main query workflows in Pinot: learning the query path, understanding SQL behavior, finding functions, choosing between SSE and MSE, using controller-managed SQL DDL for tables and materialized views, and tuning execution controls.

Next step

Read Querying Pinot if you want the end-to-end query flow, or SSE vs MSE if you are deciding which engine to use.

Related pages

• Build with Pinot

• Materialized Views

• Functions

• Reference