This is an automated email from the ASF dual-hosted git repository.
lzljs3620320 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-paimon.git
The following commit(s) were added to refs/heads/master by this push:
new 1b9463121 [doc] Fix the document of Create Table AS example (#2921)
1b9463121 is described below
commit 1b9463121dea6f24487970658cc968085d59e3cf
Author: Ron <[email protected]>
AuthorDate: Wed Feb 28 19:51:05 2024 +0800
[doc] Fix the document of Create Table AS example (#2921)
---
docs/content/how-to/creating-tables.md | 20 ++++++++++----------
1 file changed, 10 insertions(+), 10 deletions(-)
diff --git a/docs/content/how-to/creating-tables.md
b/docs/content/how-to/creating-tables.md
index 0a01662a0..4364d3077 100644
--- a/docs/content/how-to/creating-tables.md
+++ b/docs/content/how-to/creating-tables.md
@@ -335,7 +335,7 @@ CREATE TABLE my_table (
user_id BIGINT,
item_id BIGINT
);
-CREATE TABLE my_table As AS SELECT * FROM my_table;
+CREATE TABLE my_table_as AS SELECT * FROM my_table;
/* partitioned table */
CREATE TABLE my_table_partition (
@@ -345,14 +345,14 @@ CREATE TABLE my_table_partition (
dt STRING,
hh STRING
) PARTITIONED BY (dt, hh);
-CREATE TABLE my_table_partition As WITH ('partition' = 'dt') AS SELECT * FROM
my_table_partition;
+CREATE TABLE my_table_partition_as WITH ('partition' = 'dt') AS SELECT * FROM
my_table_partition;
/* change options */
CREATE TABLE my_table_options (
user_id BIGINT,
item_id BIGINT
) WITH ('file.format' = 'orc');
-CREATE TABLE my_table_options As WITH ('file.format' = 'parquet') AS SELECT *
FROM my_table_options;
+CREATE TABLE my_table_options_as WITH ('file.format' = 'parquet') AS SELECT *
FROM my_table_options;
/* primary key */
CREATE TABLE my_table_pk (
@@ -363,7 +363,7 @@ CREATE TABLE my_table_pk (
hh STRING,
PRIMARY KEY (dt, hh, user_id) NOT ENFORCED
);
-CREATE TABLE my_table_pk As WITH ('primary-key' = 'dt,hh') AS SELECT * FROM
my_table_pk;
+CREATE TABLE my_table_pk_as WITH ('primary-key' = 'dt,hh') AS SELECT * FROM
my_table_pk;
/* primary key + partition */
@@ -375,7 +375,7 @@ CREATE TABLE my_table_all (
hh STRING,
PRIMARY KEY (dt, hh, user_id) NOT ENFORCED
) PARTITIONED BY (dt, hh);
-CREATE TABLE my_table_all As WITH ('primary-key' = 'dt,hh', 'partition' =
'dt') AS SELECT * FROM my_table_all;
+CREATE TABLE my_table_all_as WITH ('primary-key' = 'dt,hh', 'partition' =
'dt') AS SELECT * FROM my_table_all;
```
{{< /tab >}}
@@ -387,7 +387,7 @@ CREATE TABLE my_table (
user_id BIGINT,
item_id BIGINT
);
-CREATE TABLE my_table As AS SELECT * FROM my_table;
+CREATE TABLE my_table_as AS SELECT * FROM my_table;
/* partitioned table*/
CREATE TABLE my_table_partition (
@@ -397,14 +397,14 @@ CREATE TABLE my_table_partition (
dt STRING,
hh STRING
) PARTITIONED BY (dt, hh);
-CREATE TABLE my_table_partition As PARTITIONED BY (dt) AS SELECT * FROM
my_table_partition;
+CREATE TABLE my_table_partition_as PARTITIONED BY (dt) AS SELECT * FROM
my_table_partition;
/* change TBLPROPERTIES */
CREATE TABLE my_table_options (
user_id BIGINT,
item_id BIGINT
) TBLPROPERTIES ('file.format' = 'orc');
-CREATE TABLE my_table_options As TBLPROPERTIES ('file.format' = 'parquet') AS
SELECT * FROM my_table_options;
+CREATE TABLE my_table_options_as TBLPROPERTIES ('file.format' = 'parquet') AS
SELECT * FROM my_table_options;
/* primary key */
@@ -417,7 +417,7 @@ CREATE TABLE my_table_pk (
) TBLPROPERTIES (
'primary-key' = 'dt,hh,user_id'
);
-CREATE TABLE my_table_pk As TBLPROPERTIES ('primary-key' = 'dt') AS SELECT *
FROM my_table_pk;
+CREATE TABLE my_table_pk_as TBLPROPERTIES ('primary-key' = 'dt') AS SELECT *
FROM my_table_pk;
/* primary key + partition */
CREATE TABLE my_table_all (
@@ -429,7 +429,7 @@ CREATE TABLE my_table_all (
) PARTITIONED BY (dt, hh) TBLPROPERTIES (
'primary-key' = 'dt,hh,user_id'
);
-CREATE TABLE my_table_all As PARTITIONED BY (dt) TBLPROPERTIES ('primary-key'
= 'dt,hh') AS SELECT * FROM my_table_all;
+CREATE TABLE my_table_all_as PARTITIONED BY (dt) TBLPROPERTIES ('primary-key'
= 'dt,hh') AS SELECT * FROM my_table_all;
```
{{< /tab >}}
