Can you try the URI of local file format, something like this:
hiveContext.hql("SET
hive.metastore.warehouse.dir=file:///home/spark/hive/warehouse")
Yong
> Date: Thu, 9 Apr 2015 04:59:00 -0700
> From: inv...@gmail.com
> To: user@spark.apache.org
> Subject: SQL can't not create Hive database
>
> Hi,
>
> I am working on the local mode.
>
> The following code
>
> hiveContext.setConf("hive.metastore.warehouse.dir",
> /home/spark/hive/warehouse)
> hiveContext.sql("create database if not exists db1")
>
> throws
>
> 15/04/09 13:53:16 ERROR RetryingHMSHandler: MetaException(message:Unable to
> create database path file:/user/hive/warehouse/db1.db, failed to create
> database db1)
>
> It seems that it uses hdfs path, not the local one specified in hiveContext.
>
> Any idea ? Thank you.
>
> Hao
>
>
>
>
> --
> View this message in context:
> http://apache-spark-user-list.1001560.n3.nabble.com/SQL-can-t-not-create-Hive-database-tp22435.html
> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
> For additional commands, e-mail: user-h...@spark.apache.org
>