codope commented on code in PR #7965: URL: https://github.com/apache/hudi/pull/7965#discussion_r1112970167
########## website/docs/querying_data.md: ########## @@ -246,10 +262,87 @@ would ensure Map Reduce execution is chosen for a Hive query, which combines par separated) and calls InputFormat.listStatus() only once with all those partitions. ## PrestoDB -To setup PrestoDB for querying Hudi, see the [Query Engine Setup](/docs/query_engine_setup#prestodb) page. + +PrestoDB is a popular query engine, providing interactive query performance. One can use both the Hive or Hudi connector ( +Presto version 0.275 onwards) for querying Hudi tables. Both connectors currently support snapshot querying on +COPY_ON_WRITE tables, and snapshot and read optimized queries on MERGE_ON_READ Hudi tables. + +Since PrestoDB-Hudi integration has evolved over time, the installation instructions for PrestoDB would vary based on +versions. Please check the below table for query types supported and installation instructions for different versions of +PrestoDB. + +| **PrestoDB Version** | **Installation description** | **Query types supported** | +|----------------------|------------------------------|---------------------------| +| < 0.233 | Requires the `hudi-presto-bundle` jar to be placed into `<presto_install>/plugin/hive-hadoop2/`, across the installation. | Snapshot querying on COW tables. Read optimized querying on MOR tables. | +| > = 0.233 | No action needed. Hudi (0.5.1-incubating) is a compile time dependency. | Snapshot querying on COW tables. Read optimized querying on MOR tables. | +| > = 0.240 | No action needed. Hudi 0.5.3 version is a compile time dependency. | Snapshot querying on both COW and MOR tables. | +| > = 0.268 | No action needed. Hudi 0.9.0 version is a compile time dependency. | Snapshot querying on bootstrap tables. | +| > = 0.272 | No action needed. Hudi 0.10.1 version is a compile time dependency. | File listing optimizations. Improved query performance. | +| > = 0.275 | No action needed. Hudi 0.11.0 version is a compile time dependency. | All of the above. Native Hudi connector that is on par with Hive connector. | + +To learn more about the usage of Hudi connector, please +checkout [prestodb documentation](https://prestodb.io/docs/current/connector/hudi.html). + +:::note Incremental queries and point in time queries are not supported either through the Hive connector or Hudi Review Comment: Done. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@hudi.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
