Michael, Thanks
- Terry Michael Armbrust <mich...@databricks.com>于2015年7月11日星期六 04:02写道: > Metastore configuration should be set in hive-site.xml. > > On Thu, Jul 9, 2015 at 8:59 PM, Terry Hole <hujie.ea...@gmail.com> wrote: > >> Hi, >> >> I am trying to set the hive metadata destination to a mysql database in >> hive context, it works fine in spark 1.3.1, but it seems broken in spark >> 1.4.1-rc1, where it always connect to the default metadata: local), is this >> a regression or we must set the connection in hive-site.xml? >> >> The code is very simple in spark shell: >> * import org.apache.spark.sql.hive._* >> * val hiveContext = new HiveContext(sc)* >> * hiveContext.setConf("javax.jdo.option.ConnectionDriveName", >> "com.mysql.jdbc.Driver")* >> * hiveContext.setConf("javax.jdo.option.ConnectionUserName", "hive")* >> * hiveContext.setConf("javax.jdo.option.ConnectionPassword", "hive")* >> * hiveContext.setConf("javax.jdo.option.ConnectionURL", >> "jdbc:mysql://10.111.3.186:3306/hive <http://10.111.3.186:3306/hive>")* >> * hiveContext.setConf("hive.metastore.warehouse.dir", >> "/user/hive/warehouse")* >> * hiveContext.sql("select * from mysqltable").show()* >> >> *Thanks!* >> *-Terry* >> >> >