[SPARK-35356] Fix issue of the createTable when externalCatalog is InMemoryCatalog

• Type: Bug
• Status: In Progress
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: yikaifei
• Created: 09/May/21 14:32
• Updated: 12/May/21 01:24

Description

In the case of externalCatalog is InMemoryCatalog, Using a different SparkSession will report the following error when create the same table , as follow

sparkSession.sql("create table if not exists t1 (id Int) using orc")
sparkSession.sql("insert into t1 values(1)")

// will report error as follow
sparkSession2.sql("create table if not exists t1 (id Int) using orc") 

Can not create the managed table('`default`.`t1`'). The associated location('file:***/t1') already exists.

Issue Links

• links to: [Github] Pull Request #32486 (yikf)
• links to: [Github] Pull Request #32486 (yikf)