arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

V2 Multi-Stage Query Engine

hashtag
Overview

The new multi-stage query engine (a.k.a V2 query engine) is designed to support more complex SQL semantics such as JOIN, OVER window, MATCH_RECOGNIZE and eventually, make Pinot support closer to full ANSI SQL semantics.

Scatter-Gather Query Engine

It also resolves the bottleneck effect for the broker reduce stage where only a single machine is dedicated to perform heavy lifting such as high cardinality GROUP BY result merging; ORDER BY sorting, etc.

hashtag
How to use the V2 query engine

To enable the V2 engine,

  1. please make sure to either

    • using the latest master commit.

    • Download the latest Apache Pinot docker image using the .

hashtag
Design Details

The overall PEP design doc and discussion can be found in the following links

  • and

Please add the following configurations to your cluster config:

  • Start the cluster normally, you should see the following window in the controller query page:

    Sample Query Screenshot
  • Building Apache Pinotarrow-up-right
    official guidearrow-up-right
    PEP discussion Github Issuearrow-up-right
    PEP design docarrow-up-right
    Pinot Multi-Stage Query Engine
    Multi-Stage Query Engine
    Scatter-Gather Query Engine
    "pinot.multistage.engine.enabled": "true",
    "pinot.server.instance.currentDataTableVersion": "4",
    "pinot.query.server.port": "8421",
    "pinot.query.runner.port": "8442"