Hortonworks sandbox $HIVE_HOME path

Question

I am back again with a stupid question i think. I downloaded the Hortonworks sandbox and tried :

echo $HIVE_HOME

and nothing. Can someone guide me what the path might be ? In the hive-site.xml i get the below lines:

<property>
  <name>hive.metastore.warehouse.dir</name>
  <value>/apps/hive/warehouse</value>
</property>

But this path doesn't exists on the box. Any help is much appreciated!!

ForeverLearner · Accepted Answer · 2015-09-25T07:24:51.897

1

Sorry for bothering. The path is :

hadoop fs -ls /apps/hive/warehouse/

    [root@sandbox current]# vi /etc/hive/conf.install/hive-site.xml

Searched for the warehouse path and got /apps/hive/warehouse

edited Sep 25 '15 at 07:24

answered Sep 14 '15 at 17:56

ForeverLearner

score 0 · Answer 2 · answered Oct 05 '15 at 01:56

Have you tried editing the .bashrc and setting your $HIVE_HOME environment variable?

Try this

sudo gedit ~/.bashrc

Copy and paste the following lines at end of the file

# Set HIVE_HOME export HIVE_HOME="/usr/lib/hive/apache-hive-0.13.0-bin" PATH=$PATH:$HIVE_HOME/bin export PATH

You can look at this page and maybe that will help you further http://doctuts.readthedocs.org/en/latest/hive.html

score 0 · Answer 3 · answered Dec 24 '16 at 09:48

There are a few ways to find Hive warehouse directory:

Check the hive configuration and search for warehouse.dir: cat /etc/hive/conf/hive-site.xml | less To search, inside less type /warehouse.dir (when done, press q to exit less). <property> <name>hive.metastore.warehouse.dir</name> <value>/apps/hive/warehouse</value> </property>
Execute the SET Hive QL command. You can run it in Hue (in Amabri switch to Hive view) or in the command line. I will show you how to run it in command line and find the parameter.: [maria_dev@sandbox learn]$ hive -S -e 'SET' 2>/dev/null | grep warehouse.dir hive.metastore.warehouse.dir=/apps/hive/warehouse Because Hive prints a lot of information to the stderr, I added the 2>/dev/null output redirect to supress the stderr output from being written to the console.

3 Answers3