This is an automated email from the ASF dual-hosted git repository.
bhavanisudha pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/hudi.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 2581eba7cc [HUDI-2695] Update Trino section with new connector (#6979)
2581eba7cc is described below
commit 2581eba7ccc7ecc5e04bfaf46d28d4d67ef74bf4
Author: Sagar Sumit <[email protected]>
AuthorDate: Tue Oct 18 23:51:19 2022 +0530
[HUDI-2695] Update Trino section with new connector (#6979)
---
website/docs/query_engine_setup.md | 10 +++++++++-
1 file changed, 9 insertions(+), 1 deletion(-)
diff --git a/website/docs/query_engine_setup.md
b/website/docs/query_engine_setup.md
index ddf04b080a..40cdabbd43 100644
--- a/website/docs/query_engine_setup.md
+++ b/website/docs/query_engine_setup.md
@@ -70,10 +70,18 @@ Beginning query by connecting hive metastore with presto
client. The presto clie
```
## Trino
+
+Just like PrestoDB, there are two ways to query Hudi tables using Trino i.e.
either using Hive connector or the native
+Hudi connector. If you're on Trino version **398** or higher, it is
recommended to use the Hudi connector. To learn more
+about the usage of Hudi connector, please check out the [connector
documentation](https://trino.io/docs/current/connector/hudi.html).
+Both the connectors are on par in terms of query support, i.e. 'Snapshot'
queries for Copy-On-Write tables and
+'Read Optimized' queries for Merge-On-Read tables.
+
:::note
[Trino](https://trino.io/) (formerly PrestoSQL) was forked off of PrestoDB a
few years ago. Hudi supports 'Snapshot' queries for Copy-On-Write tables and
'Read Optimized' queries
for Merge-On-Read tables. This is through the initial input format based
integration in PrestoDB (pre forking). This approach has
-known performance limitations with very large tables, which has been since
fixed on PrestoDB. We are working on replicating the same fixes on Trino as
well.
+known performance limitations with very large tables, which has been since
fixed on PrestoDB.
+We recommend using the new Hudi connector in Trino (released since Trino
version 398).
:::
To query Hudi tables on Trino, please place the `hudi-trino-bundle` jar into
the Hive connector installation `<trino_install>/plugin/hive-hadoop2`.
