This is an automated email from the ASF dual-hosted git repository.
weichiu pushed a commit to branch HDDS-9225-website-v2
in repository https://gitbox.apache.org/repos/asf/ozone-site.git
The following commit(s) were added to refs/heads/HDDS-9225-website-v2 by this
push:
new 54708aad7 HDDS-11931. Populate impala.md file under Integration
section (#161)
54708aad7 is described below
commit 54708aad7527c06bae66827025c52339c25dd97b
Author: rnblough <[email protected]>
AuthorDate: Wed Jan 14 14:30:25 2026 -0500
HDDS-11931. Populate impala.md file under Integration section (#161)
Co-authored-by: Wei-Chiu Chuang <[email protected]>
---
docs/04-user-guide/03-integrations/04-impala.md | 82 ++++++++++++++++++++++++-
1 file changed, 81 insertions(+), 1 deletion(-)
diff --git a/docs/04-user-guide/03-integrations/04-impala.md
b/docs/04-user-guide/03-integrations/04-impala.md
index 1682a1c3f..d48629bc4 100644
--- a/docs/04-user-guide/03-integrations/04-impala.md
+++ b/docs/04-user-guide/03-integrations/04-impala.md
@@ -1,3 +1,83 @@
+---
+sidebar_label: Impala
+---
+
# Impala
-**TODO:** File a subtask under
[HDDS-9858](https://issues.apache.org/jira/browse/HDDS-9858) and complete this
page or section.
+Starting with version 4.2.0, Apache Impala provides full support for querying
data stored in Apache Ozone. To utilize this functionality, ensure that your
Ozone version is 1.4.0 or later.
+
+## Supported Access Protocols
+
+Impala supports the following protocols for accessing Ozone data:
+
+- ofs
+- s3a
+
+Note: The o3fs protocol is **NOT** supported by Impala.
+
+## Supported Replication Types
+
+Impala is compatible with Ozone buckets configured with either:
+
+- **RATIS** (Replication)
+- **Erasure Coding**
+
+## Querying Ozone Data with Impala
+
+Impala provides two approaches to interact with Ozone:
+
+- Managed Tables
+- External Tables
+
+### Managed Tables
+
+If the Hive Warehouse Directory is located in Ozone, you can execute Impala
queries without any changes, treating the Ozone file system like HDFS. For
example:
+
+```sql
+CREATE DATABASE d1;
+```
+
+```sql
+CREATE TABLE t1 (x INT, s STRING);
+```
+
+The data will be stored under the Hive Warehouse Directory path in Ozone.
+
+#### Specifying a Custom Ozone Path
+
+You can create managed databases, tables, or partitions at a specific Ozone
path using the `LOCATION` clause. Example:
+
+```sql
+CREATE DATABASE d1 LOCATION 'ofs://ozone1/vol1/bucket1/d1.db';
+```
+
+```sql
+CREATE TABLE t1 LOCATION 'ofs://ozone1/vol1/bucket1/table1';
+```
+
+### External Tables
+
+You can create an external table in Impala to query Ozone data. For example:
+
+```sql
+CREATE EXTERNAL TABLE external_table (
+ id INT,
+ name STRING
+)
+LOCATION 'ofs://ozone1/vol1/bucket1/table1';
+```
+
+- With external tables, the data is expected to be created and managed by
another tool.
+- Impala queries the data as-is.
+- The metadata is stored under the external warehouse directory.
+- Note: Dropping an external table in Impala does not delete the associated
data.
+
+## Using the S3A Protocol
+
+In addition to ofs, Impala can access Ozone via the S3 Gateway using the S3A
file system. For more details, refer to
+
+- The [S3 Protocol](../01-client-interfaces/03-s3/01-s3-api.md)
+- The [Hadoop
S3A](https://hadoop.apache.org/docs/current/hadoop-aws/tools/hadoop-aws/index.html)
documentation.
+
+For additional information, consult the Apache Impala User Documentation
+[Using Impala with Apache Ozone
Storage](https://impala.apache.org/docs/build/html/topics/impala_ozone.html).
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
