CODEWITHSUNDEEP
hadoopapache-hive
wazza
wazza

Reputation: 800

default.fs.name and hive.metastore.warehouse.dir do not conflict

Hi When I try to run the below command 

Load data Inpath '/data' into Table Tablename;

in hive shell it throws following error

Move from: hdfs://hadoopcluster/data to: file:/user/hive/warehouse/Tablename is not valid. Please check that values for params "default.fs.name" and "hive.metastore.warehouse.dir" do not conflict.

where my default.fs.name property is

<property>
 <name>fs.defaultFS</name>
 <value>hdfs://hadoopcluster</value>
 </property>

where my hive.metastore.warehouse.dir is

 <property>
    <name>hive.metastore.warehouse.dir</name>
    <value>/user/hive/warehouse</value>
    <description>location of default database for the warehouse</description>
  </property>

Can any one help me in this?

Upvotes: 1

Views: 2645

Answers (1)

John
John

Reputation: 523

This is because you are using "local" storage location /user/hive/warehouse for your Hive metastore that conflicts with the defaultFS (per Hive).

Do you mean to be using "local" storage, or HDFS?

To use HDFS for the Hive metastore setting you need to specify the full HDFS URI for that storage:

hdfs://hadoopcluster/user/hive/warehouse

Upvotes: 1

Related Questions