search

apache / pinot

Apache Pinot - A realtime distributed OLAP datastore
https://pinot.apache.org/
Apache License 2.0
5.27k stars 1.23k forks source link

Remove PQL query endpoint and response format after 0.10.0 release #7430

Closed xiangfu0 closed 2 years ago

xiangfu0 commented 2 years ago

Dear Community,

TL;DR, Pinot will remove PQL query endpoint and response format after 0.10.0 release, only SQL endpoint is supported afterward.

Apache Pinot has been supporting the Calcite SQL query endpoint from 0.3.0 (Mar 2020) and deprecating the PQL query endpoint for more than a year.

Now we are seeing more obstacles to maintain two code paths for PQL & SQL for adding new functionalities, query optimization, behavior handling, etc.

So we decide to remove the PQL query path and endpoint. If you are still on the PQL query path, please migrate to SQL endpoint: https://docs.pinot.apache.org/users/user-guide-query/querying-pinot

Current timeline is driven by the next Apache Pinot release:

  1. Apache Pinot 0.10.0 release (Release date: Mar 2022) is the last official Pinot release that supports PQL.
  2. Apache Pinot master branch will remove PQL support once the 0.10.0 release is cut, and no PQL support from the 0.11.0 release.
xiangfu0 commented 2 years ago

This is huge! Big congrats!

xiangfu0 commented 2 years ago

Pinot deprecates PQL fully, only SQL endpoint is supported moving forward from 0.11.0 release.