[SPARK-19724] create a managed table with an existed default location should throw an exception

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.4.0
• Component/s: SQL
• Labels: release-notes
• Assignee: Gengliang Wang
• Reporter: Song Jun
• Created: 24/Feb/17 09:21
• Updated: 08/Nov/18 02:29
• Resolved: 19/Sep/18 00:40

Description

This JIRA is a follow up work after SPARK-19583(https://issues.apache.org/jira/browse/SPARK-19583)

As we discussed in that [PR](https://github.com/apache/spark/pull/16938)

The following DDL for a managed table with an existed default location should throw an exception:

CREATE TABLE ... (PARTITIONED BY ...) AS SELECT ...
CREATE TABLE ... (PARTITIONED BY ...)

Currently there are some situations which are not consist with above logic:

1. CREATE TABLE ... (PARTITIONED BY ...) succeed with an existed default location
situation: for both hive/datasource(with HiveExternalCatalog/InMemoryCatalog)

2. CREATE TABLE ... (PARTITIONED BY ...) AS SELECT ...
situation: hive table succeed with an existed default location

Issue Links

• links to: [Github] Pull Request #17057 (windpiger)
• links to: [Github] Pull Request #17272 (windpiger)
• links to: [Github] Pull Request #20886 (gengliangwang)
• links to: [Github] Pull Request #21001 (gengliangwang)
• links to: [Github] Pull Request #22515 (rxin)