Search code examples
hivehiveql

hive-site.xml path in hive0.13.1

I'm a newbie. I would like to know the hive-site.xml and hive-default.xml files locations in hive-0.13.1 version.

I have downloaded hive0.13.1-bin version from the below location. http://apache.mirrors.pair.com/hive/hive-0.13.1/

Extracted and then configured hive environment variables.
I'm able to run the commands(create table, show, load data, query table..).

But in the conf(/hive/hive-0.13-1/conf) directory, I do not see hive-site.xml and hive-default.xml files.

Where these files are located in hive-0.13.1 version?

Solution

  • follow the steps

    1) Extract folder

    2)go to /apache-hive-0.13.1-bin/conf and make a copy of hive-default.xml.template , it looks like hive-default.xml (copy).template.

    3) Rename hive-default.xml (copy).template to hive-site.xml.

    4) Make a copy of hive-env.sh.template to hive-env.sh.

    add in hive-env.sh

    export HADOOP_HEAPSIZE=1024
# Set HADOOP_HOME to point to a specific hadoop install directory
export HADOOP_HOME=/home/user17/BigData/hadoop

#hive 
export HIVE_HOME=/home/user17/BigData/hive
# Hive Configuration Directory can be controlled by:
export HIVE_CONF_DIR=$HIVE_HOME/conf

    5) export hadoop and hive path in .bashrc file

    export HADOOP_HOME=/home/user17/BigData/hadoop
export PATH=$PATH:$HADOOP_HOME/bin

export HIVE_HOME=/home/user17/BigData/hive
export PATH=$PATH:$HIVE_HOME/bin

    start your hadoop by

    start-all.sh

    enjoy with your hive.Give the hadoop and hive path in export command according to your system.let me know if not work.