Hacker News new | ask | show | jobs
by b0b0b0b 4601 days ago
What are the access paths that presto uses (full scan, range scan, skip scan, ...)? Does it understand indexes?
1 comments

Presto supports full scan right now, but pushes down key value equality pairs to the connectors for additional connector side pruning (e.g. partitions in Hive). The engine itself will also do some additional partition pruning at planning time with the partitions returned by the connector.

We currently have a pull request open right now that will allow range predicates to be be pushed into the connectors. This will allow connectors the ability to implement range/skip scans.

The core presto engine does not take advantage of indexes right now.