Re: SQL can't not create Hive database

Can you create the database directly within Hive? If you're getting the same error within Hive, it sounds like a permissions issue as per Bojan. More info can be found at: http://stackoverflow.com/questions/15898211/unable-to-create-database-path-file-user-hive-warehouse-error On Thu, Apr 9, 201

Re: SQL can't not create Hive database

I think it uses local dir, hdfs dir path starts with hdfs:// Check permissions on folders, and also check logs. There should be more info about exception. Best Bojan -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/SQL-can-t-not-create-Hive-database-tp22435

RE: SQL can't not create Hive database

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'

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