Presto
Integrate with Presto for ad-hoc queries with Full SQL
Last updated
Was this helpful?
Integrate with Presto for ad-hoc queries with Full SQL
Last updated
Was this helpful?
Start running with pre-built .
Run below command to start a standalone Presto coordinator.
Then you can connect to presto with .
Then write your own queries;
Presto supports aggregation and predicate push down to Pinot. However, for certain queries that Pinot doesn't handle, Presto tries to fetch all the rows from the Pinot table segment by segment. This is definitely not an ideal access pattern for Pinot.
In order to support large data scanning, Pinot (>=0.6.0) introduces a gRPC server for on-demand data scanning with a reasonable smaller memory footprint.
You can enable it by adding the below configs to the Pinot server config file:
Then you can enable the streaming connector in Presto(>=0.244) by adding the below config to the Pinot catalog configs.
(Disclaimer: Presto is a third-party software that is not part of the Apache Software Foundation).
Meanwhile you can access to see query stats.