CODEWITHSUNDEEP
hadoophivebigdatasqoophiveql
Jomy
Jomy

Reputation: 87

Changing the Target directory in HIVE

I am importing a table from NETEZZA into HIVE. I have explicitly mentioned my target directory in the SQOOP command, but it always takes the default path: /user/hive/warehouse

How to change this default path??

Upvotes: 1

Views: 1730

Answers (1)

Junayy
Junayy

Reputation: 1150

In $HIVE_CONF/conf/hive-site.xml you have to put this :

<property>
  <name>hive.metastore.warehouse.dir</name>
  <value>your/directory/in/hdfs</value>
</property>

And then restart hive.

Upvotes: 2

Related Questions