This is an automated email from the ASF dual-hosted git repository.
yumwang pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 6b7b3ca [MINOR][DOCS] Add table_identifier in sql-migration-guide for
SHOW CREATE TABLE
6b7b3ca is described below
commit 6b7b3ca898e6896c28ed14a398a62c925ceddca4
Author: Karl-WangSK <shikai.w...@linkflowtech.com>
AuthorDate: Mon Feb 22 20:15:19 2021 +0800
[MINOR][DOCS] Add table_identifier in sql-migration-guide for SHOW CREATE
TABLE
### What changes were proposed in this pull request?
Add `table_identifier` in sql-migration-guide for SHOW CREATE TABLE.
### Why are the changes needed?
To make document more readable.
### Does this PR introduce _any_ user-facing change?
No.
### How was this patch tested?
Existing test suites.
Closes #31608 from Karl-WangSK/sqldoc.
Lead-authored-by: Karl-WangSK <shikai.w...@linkflowtech.com>
Co-authored-by: ShiKai Wang <wskq...@gmail.com>
Signed-off-by: Yuming Wang <yumw...@ebay.com>
(cherry picked from commit a6a82c8e69eedb4ab83c99fb71772553a0ea4e84)
Signed-off-by: Yuming Wang <yumw...@ebay.com>
---
docs/sql-migration-guide.md | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/docs/sql-migration-guide.md b/docs/sql-migration-guide.md
index 742a05b..4ab92e1 100644
--- a/docs/sql-migration-guide.md
+++ b/docs/sql-migration-guide.md
@@ -71,7 +71,7 @@ license: |
- In Spark 3.0, `SHOW TBLPROPERTIES` throws `AnalysisException` if the table
does not exist. In Spark version 2.4 and below, this scenario caused
`NoSuchTableException`.
- - In Spark 3.0, `SHOW CREATE TABLE` always returns Spark DDL, even when the
given table is a Hive SerDe table. For generating Hive DDL, use `SHOW CREATE
TABLE AS SERDE` command instead.
+ - In Spark 3.0, `SHOW CREATE TABLE table_identifier` always returns Spark
DDL, even when the given table is a Hive SerDe table. For generating Hive DDL,
use `SHOW CREATE TABLE table_identifier AS SERDE` command instead.
- In Spark 3.0, column of CHAR type is not allowed in non-Hive-Serde tables,
and CREATE/ALTER TABLE commands will fail if CHAR type is detected. Please use
STRING type instead. In Spark version 2.4 and below, CHAR type is treated as
STRING type and the length parameter is simply ignored.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org
For additional commands, e-mail: commits-h...@spark.apache.org
