[SPARK-18050] spark 2.0.1 enable hive throw AlreadyExistsException(message:Database default already exists)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Component/s: SQL

Environment

jdk1.8, macOs,spark 2.0.1

• Target Version/s: 2.1.0
• Assignee: Wenchen Fan
• Reporter: todd.chen
• Created: 21/Oct/16 13:53
• Updated: 23/Nov/16 17:56
• Resolved: 23/Nov/16 17:56

Description

in spark 2.0.1 ,I enable hive support and when init the sqlContext ,throw a AlreadyExistsException(message:Database default already exists),same as
https://www.mail-archive.com/[e-mail]/msg15306.html ,my code is

  private val master = "local[*]"
  private val appName = "xqlServerSpark"
  val fileSystem = FileSystem.get()
  val sparkConf = new SparkConf().setMaster(master).
    setAppName(appName).set("spark.sql.warehouse.dir", s"${fileSystem.getUri.toASCIIString}/user/hive/warehouse")
  val   hiveContext = SparkSession.builder().config(sparkConf).enableHiveSupport().getOrCreate().sqlContext
    print(sparkConf.get("spark.sql.warehouse.dir"))
    hiveContext.sql("show tables").show()

the result is correct,but a exception also throwBy the code

Issue Links

• links to: [Github] Pull Request #15993 (cloud-fan)