This is an automated email from the ASF dual-hosted git repository.
fanng pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/gravitino.git
The following commit(s) were added to refs/heads/main by this push:
new 972edc118 [Minor] fix(docs): Fix docs mistake for partitioned table
created by Trino (#4813)
972edc118 is described below
commit 972edc11875c13906ca83fbc8c3760adccce514d
Author: Qi Yu <[email protected]>
AuthorDate: Fri Aug 30 17:38:38 2024 +0800
[Minor] fix(docs): Fix docs mistake for partitioned table created by Trino
(#4813)
### What changes were proposed in this pull request?
Fix the error in the example SQL.
### Why are the changes needed?
For a better user experience.
### Does this PR introduce _any_ user-facing change?
N/A
### How was this patch tested?
N/A.
---
docs/trino-connector/catalog-hive.md | 9 +++++----
1 file changed, 5 insertions(+), 4 deletions(-)
diff --git a/docs/trino-connector/catalog-hive.md
b/docs/trino-connector/catalog-hive.md
index 72e70d3fd..d162beaff 100644
--- a/docs/trino-connector/catalog-hive.md
+++ b/docs/trino-connector/catalog-hive.md
@@ -221,11 +221,12 @@ Create a new table named `table_01` in schema
`hive_test.database_01` and stored
CREATE TABLE hive_test.database_01.table_01
(
name varchar,
-salary int
+salary int,
+month int
)
WITH (
format = 'TEXTFILE',
- partitioned_by = ARRAY['salary'],
+ partitioned_by = ARRAY['month'],
bucketed_by = ARRAY['name'],
bucket_count = 2,
sorted_by = ARRAY['salary']
@@ -237,13 +238,13 @@ WITH (
Insert data into the table `table_01`:
```sql
-INSERT INTO hive_test.database_01.table_01 (name, salary) VALUES ('ice', 12);
+INSERT INTO hive_test.database_01.table_01 (name, salary) VALUES ('ice', 12,
22);
```
Insert data into the table `table_01` from select:
```sql
-INSERT INTO hive_test.database_01.table_01 (name, salary) SELECT * FROM
hive_test.database_01.table_01;
+INSERT INTO hive_test.database_01.table_01 (name, salary, month) SELECT * FROM
hive_test.database_01.table_01;
```
### Querying data