[SPARK-17353] CREATE TABLE LIKE statements when Source is a VIEW

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.1
• Fix Version/s: 2.0.1, 2.1.0
• Component/s: SQL
• Target Version/s: 2.0.1, 2.1.0
• Assignee: Xiao Li
• Reporter: Xiao Li
• Created: 01/Sep/16 03:28
• Updated: 06/Sep/16 02:47
• Resolved: 01/Sep/16 08:39

Description

• Add a support for tempory view

• When the source table is a `VIEW`, the metadata of the generated table contains the original view text and view original text. So far, this does not break anything, but it could cause something wrong in Hive. (For example, https://github.com/apache/hive/blob/master/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java#L1405-L1406)

• When the type of source table is a view, the target table is using the default format of data source tables: `spark.sql.sources.default`.

Issue Links

• links to: [Github] Pull Request #14531 (gatorsmile)
• links to: [Github] Pull Request #14946 (gatorsmile)