# For Users

- [Query](/release-1.3.0/for-users/user-guide-query.md): Learn how to query Apache Pinot using SQL or explore data using the web-based Pinot query console.
- [Querying Pinot](/release-1.3.0/for-users/user-guide-query/querying-pinot.md): Learn how to query Pinot using SQL
- [Query Syntax](/release-1.3.0/for-users/user-guide-query/query-syntax.md): Query Pinot using supported syntax.
- [Aggregation Functions](/release-1.3.0/for-users/user-guide-query/query-syntax/supported-aggregations.md): Aggregate functions return a single result for a group of rows.
- [Array Functions](/release-1.3.0/for-users/user-guide-query/query-syntax/array-functions.md)
- [Cardinality Estimation](/release-1.3.0/for-users/user-guide-query/query-syntax/how-to-handle-unique-counting.md)
- [Explain Plan (Single-Stage)](/release-1.3.0/for-users/user-guide-query/query-syntax/explain-plan.md)
- [Filtering with IdSet](/release-1.3.0/for-users/user-guide-query/query-syntax/filtering-with-idset.md): Learn how to write fast queries for looking up IDs in a list of values.
- [Funnel Analysis](/release-1.3.0/for-users/user-guide-query/query-syntax/funnel-analysis.md)
- [GapFill Function For Time-Series Dataset](/release-1.3.0/for-users/user-guide-query/query-syntax/gap-fill-functions.md)
- [Grouping Algorithm](/release-1.3.0/for-users/user-guide-query/query-syntax/grouping-algorithm.md)
- [Hash Functions](/release-1.3.0/for-users/user-guide-query/query-syntax/hash-functions.md)
- [JOINs](/release-1.3.0/for-users/user-guide-query/query-syntax/joins.md): Pinot supports JOINs, including left, right, full, semi, anti, lateral, and equi JOINs. Use JOINs to connect two table to generate a unified view, based on a related column between the tables.
- [Lookup UDF Join](/release-1.3.0/for-users/user-guide-query/query-syntax/lookup-udf-join.md): For more information about using JOINs with the multi-stage query engine, see JOINs.
- [Querying JSON data](/release-1.3.0/for-users/user-guide-query/query-syntax/json-queries.md)
- [Transformation Functions](/release-1.3.0/for-users/user-guide-query/query-syntax/supported-transformations.md): This document contains the list of all the transformation functions supported by Pinot SQL.
- [URL Functions](/release-1.3.0/for-users/user-guide-query/query-syntax/url-functions.md)
- [Window Functions](/release-1.3.0/for-users/user-guide-query/query-syntax/windows-functions.md): Use window functions to compute averages, sort, rank, or count items, calculate sums, and find minimum or maximum values across windows.
- [Query Options](/release-1.3.0/for-users/user-guide-query/query-options.md): This document contains all the available query options
- [Query Quotas](/release-1.3.0/for-users/user-guide-query/query-quotas.md)
- [Query using Cursors](/release-1.3.0/for-users/user-guide-query/query-using-cursors.md)
- [Multi-stage query](/release-1.3.0/for-users/user-guide-query/multi-stage-query.md): Learn more about multi-stage query engine and how to troubleshoot issues.
- [Understanding Stages](/release-1.3.0/for-users/user-guide-query/multi-stage-query/understanding-stages.md): Learn more about multi-stage stages and how to extract stages from query plans.
- [Stats](/release-1.3.0/for-users/user-guide-query/multi-stage-query/understanding-stage-stats.md): Learn more about multi-stage stats and how to use them to improve your queries.
- [Optimizing joins](/release-1.3.0/for-users/user-guide-query/multi-stage-query/optimizing-joins.md): Tips and tricks that can be used to optimize joins
- [Join strategies](/release-1.3.0/for-users/user-guide-query/multi-stage-query/join-strategies.md)
- [Random + broadcast join strategy](/release-1.3.0/for-users/user-guide-query/multi-stage-query/join-strategies/random-+-broadcast-join-strategy.md)
- [Query time partition join strategy](/release-1.3.0/for-users/user-guide-query/multi-stage-query/join-strategies/query-time-partition-join-strategy.md)
- [Colocated join strategy](/release-1.3.0/for-users/user-guide-query/multi-stage-query/join-strategies/colocated-join-strategy.md)
- [Lookup join strategy](/release-1.3.0/for-users/user-guide-query/multi-stage-query/join-strategies/lookup-join-strategy.md)
- [Hints](/release-1.3.0/for-users/user-guide-query/multi-stage-query/hints.md)
- [Operator Types](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types.md): Describes the multi-stage operators in general
- [Aggregate](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/aggregate.md): Describes the aggregate relation operator in the multi-stage query engine.
- [Filter](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/filter.md): Describes the filter relation operator in the multi-stage query engine.
- [Join](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/hash_join.md): Describes the hash join relation operator in the multi-stage query engine.
- [Intersect](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/intersect.md): Describes the intersect relation operator in the multi-stage query engine.
- [Leaf](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/leaf.md): Describes the leaf operator in the multi-stage query engine.
- [Literal](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/literal.md): Describes the literal relation operator in the multi-stage query engine.
- [Mailbox receive](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/mailbox-receive.md): Describes the mailbox receive operator in the multi-stage query engine.
- [Mailbox send](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/mailbox-send.md): Describes the mailbox send operator in the multi-stage query engine.
- [Minus](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/minus.md): Describes the minus relation operator in the multi-stage query engine.
- [Sort or limit](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/sortorlimit.md): Describes the sort or limit relation operator in the multi-stage query engine.
- [Transform](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/transform.md): Describes the transform relation operator in the multi-stage query engine.
- [Union](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/union.md): Describes the union relation operator in the multi-stage query engine.
- [Window](/release-1.3.0/for-users/user-guide-query/multi-stage-query/operator-types/window.md): Describes the window relational operator in the multi-stage query engine.
- [Stage-Level Spooling](/release-1.3.0/for-users/user-guide-query/multi-stage-query/stage-level-spooling.md): Also know as reuse common expressions
- [User-Defined Functions (UDFs)](/release-1.3.0/for-users/user-guide-query/scalar-functions.md)
- [Explain plan](/release-1.3.0/for-users/user-guide-query/explain-plan-1.md)
- [APIs](/release-1.3.0/for-users/api.md)
- [Broker Query API](/release-1.3.0/for-users/api/querying-pinot-using-standard-sql.md)
- [Query Response Format](/release-1.3.0/for-users/api/querying-pinot-using-standard-sql/response-format.md)
- [Controller Admin API](/release-1.3.0/for-users/api/pinot-rest-admin-interface.md)
- [Controller API Reference](/release-1.3.0/for-users/api/controller-api-reference.md): All user APIs available in Pinot
- [External Clients](/release-1.3.0/for-users/clients.md)
- [JDBC](/release-1.3.0/for-users/clients/jdbc.md)
- [Java](/release-1.3.0/for-users/clients/java.md)
- [Python](/release-1.3.0/for-users/clients/python.md)
- [Golang](/release-1.3.0/for-users/clients/golang.md): Pinot Client for Golang
- [Tutorials](/release-1.3.0/for-users/tutorials.md)
- [Use OSS as Deep Storage for Pinot](/release-1.3.0/for-users/tutorials/use-oss-as-deep-storage-for-pinot.md): Configure AliCloud Object Storage Service (OSS) as Pinot deep storage
- [Ingest Parquet Files from S3 Using Spark](/release-1.3.0/for-users/tutorials/ingest-parquet-files-from-s3-using-spark.md)
- [Creating Pinot Segments](/release-1.3.0/for-users/tutorials/create-pinot-segments.md)
- [Use S3 as Deep Storage for Pinot](/release-1.3.0/for-users/tutorials/use-s3-as-deep-store-for-pinot.md)
- [Use S3 and Pinot in Docker](/release-1.3.0/for-users/tutorials/use-s3-and-pinot-in-docker.md)
- [Batch Data Ingestion In Practice](/release-1.3.0/for-users/tutorials/batch-data-ingestion-in-practice.md)
- [Schema Evolution](/release-1.3.0/for-users/tutorials/schema-evolution.md)