[ https://issues.apache.org/jira/browse/SPARK-27946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li resolved SPARK-27946. ----------------------------- Fix Version/s: 3.0.0 Assignee: L. C. Hsieh Resolution: Fixed > Hive DDL to Spark DDL conversion USING "show create table" > ---------------------------------------------------------- > > Key: SPARK-27946 > URL: https://issues.apache.org/jira/browse/SPARK-27946 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.0.0 > Reporter: Xiao Li > Assignee: L. C. Hsieh > Priority: Major > Fix For: 3.0.0 > > > This patch adds a DDL command SHOW CREATE TABLE AS SERDE. It is used to > generate Hive DDL for a Hive table. > For original SHOW CREATE TABLE, it now shows Spark DDL always. If given a > Hive table, it tries to generate Spark DDL. > For Hive serde to data source conversion, this uses the existing mapping > inside HiveSerDe. If can't find a mapping there, throws an analysis exception > on unsupported serde configuration. > It is arguably that some Hive fileformat + row serde might be mapped to Spark > data source, e.g., CSV. It is not included in this PR. To be conservative, it > may not be supported. > For Hive serde properties, for now this doesn't save it to Spark DDL because > it may not useful to keep Hive serde properties in Spark table. -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org