Hi I am trying to run Hive in local mode, I have set the HIVE_OPTS environment variable
export HIVE_OPTS='-hiveconf
mapred.job.tracker=local
-hiveconf fs.default.name=file:////<myhomedir>/hivelocal/tmp
-hiveconf hive.metastore.warehouse.dir=file:////<myhomedir>/hivelocal/warehouse
-hiveconf javax.jdo.option.ConnectionURL=jdbc:derby:;databaseName=/<myhomedir>/hivelocal/metastore_db;create=true'
and connected to hive using hive
client
when I create the table(name demo
), I still see the table is getting created in the default
database in HDFS. I was expecting the table to be created in the local file system(file:///
) as I have the set the warehouse using hive.metastore.warehouse.dir=file:////<myhomedir>/hivelocal/warehouse
Am I missing something here?
PS : I am using Cloudera distribution