This is an automated email from the ASF dual-hosted git repository.
yihua 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 df2fad61371 [DOCS] Update about recent Athena upgrade query failures
(#10649)
df2fad61371 is described below
commit df2fad6137126bd1dadb75ccb4984dcea867ceec
Author: Sagar Sumit <[email protected]>
AuthorDate: Tue Feb 20 07:17:54 2024 +0530
[DOCS] Update about recent Athena upgrade query failures (#10649)
---
website/docs/sql_queries.md | 10 ++++++++++
website/versioned_docs/version-0.14.0/sql_queries.md | 10 ++++++++++
website/versioned_docs/version-0.14.1/sql_queries.md | 10 ++++++++++
3 files changed, 30 insertions(+)
diff --git a/website/docs/sql_queries.md b/website/docs/sql_queries.md
index 47c507c9bfb..88b7be075af 100644
--- a/website/docs/sql_queries.md
+++ b/website/docs/sql_queries.md
@@ -217,6 +217,16 @@ 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.
:::
+## AWS Athena
+
+[AWS Athena](https://aws.amazon.com/athena/) is an interactive query service
that makes it easy to analyze data in Amazon S3 using standard SQL.
+It supports [querying Hudi
tables](https://docs.aws.amazon.com/athena/latest/ug/querying-hudi.html) using
the Hive connector.
+Currently, it supports snapshot queries on COPY_ON_WRITE tables, and snapshot
and read optimized queries on MERGE_ON_READ Hudi tables.
+
+:::note The most recent release of Athena that supports querying Hudi 0.14.0
tables has a bug that causes _ro query to return 0 records, and occasionally
_rt the query to fail with class cast exception.
+The issue is tracked in
[HUDI-7362](https://issues.apache.org/jira/browse/HUDI-7362) and is expected to
be fixed in the next release.
+:::
+
## Presto
[Presto](https://prestodb.io/) is a popular query engine for interactive query
performance. Support for querying Hudi tables using PrestoDB is offered
diff --git a/website/versioned_docs/version-0.14.0/sql_queries.md
b/website/versioned_docs/version-0.14.0/sql_queries.md
index b7992d5ef6d..5a37b5ec064 100644
--- a/website/versioned_docs/version-0.14.0/sql_queries.md
+++ b/website/versioned_docs/version-0.14.0/sql_queries.md
@@ -209,6 +209,16 @@ 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.
:::
+## AWS Athena
+
+[AWS Athena](https://aws.amazon.com/athena/) is an interactive query service
that makes it easy to analyze data in Amazon S3 using standard SQL.
+It supports [querying Hudi
tables](https://docs.aws.amazon.com/athena/latest/ug/querying-hudi.html) using
the Hive connector.
+Currently, it supports snapshot queries on COPY_ON_WRITE tables, and snapshot
and read optimized queries on MERGE_ON_READ Hudi tables.
+
+:::note The most recent release of Athena that supports querying Hudi 0.14.0
tables has a bug that causes _ro query to return 0 records, and occasionally
_rt the query to fail with class cast exception.
+The issue is tracked in
[HUDI-7362](https://issues.apache.org/jira/browse/HUDI-7362) and is expected to
be fixed in the next release.
+:::
+
## Presto
[Presto](https://prestodb.io/) is a popular query engine for interactive query
performance. Support for querying Hudi tables using PrestoDB is offered
diff --git a/website/versioned_docs/version-0.14.1/sql_queries.md
b/website/versioned_docs/version-0.14.1/sql_queries.md
index 47c507c9bfb..88b7be075af 100644
--- a/website/versioned_docs/version-0.14.1/sql_queries.md
+++ b/website/versioned_docs/version-0.14.1/sql_queries.md
@@ -217,6 +217,16 @@ 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.
:::
+## AWS Athena
+
+[AWS Athena](https://aws.amazon.com/athena/) is an interactive query service
that makes it easy to analyze data in Amazon S3 using standard SQL.
+It supports [querying Hudi
tables](https://docs.aws.amazon.com/athena/latest/ug/querying-hudi.html) using
the Hive connector.
+Currently, it supports snapshot queries on COPY_ON_WRITE tables, and snapshot
and read optimized queries on MERGE_ON_READ Hudi tables.
+
+:::note The most recent release of Athena that supports querying Hudi 0.14.0
tables has a bug that causes _ro query to return 0 records, and occasionally
_rt the query to fail with class cast exception.
+The issue is tracked in
[HUDI-7362](https://issues.apache.org/jira/browse/HUDI-7362) and is expected to
be fixed in the next release.
+:::
+
## Presto
[Presto](https://prestodb.io/) is a popular query engine for interactive query
performance. Support for querying Hudi tables using PrestoDB is offered
