Configuration of Hive in Hadoop

http://10.18.51.52:9999/hwi/; This installs the Web browsing address for the configuration. Hive is Hadoop -based , so install and complete Hadoopfirst.

Export Hive_home=/usr/hive

Export hive_conf_dir= $HOME/hive-conf

Export classpath= $HIVE _home/lib: $JAVA _home/lib: $JAVA _home/jre/lib: $HADOOP _home

Export path= $HIVE _home/bin: $HADOOP _home/bin: $JAVA _home/bin:/sbin/:/bin: $PATH

Installation:

http://www.mamicode.com/info-detail-516526.html;

http://blog.chinaunix.net/uid-451-id-3143781.html;

Unzip the downloaded installation package to /usr/hive , just install it on the master node. The environment variable configuration is shown above.

Configuration:

Cp-r hive-0.8.1/conf $HIVE _conf_dir/
CD $HIVE _conf_dir/
CP Hive-default.xml.template Hive-default.xml
Cat hive-env.sh
Export hadoop_heapsize=512
Export hive_conf_dir=/usr/hive-conf

Test:

$ hive
Hive> Show tables;
Ok
Time taken:4.824 seconds
Hive> CREATE TABLE HWZ (id int, name string);
Ok
Time taken:0.566 seconds
Hive> select * from HWZ;
Ok
Time taken:0.361 seconds

Hadoop dfs-lsr/user/hive

Compile:

(generally download the corresponding version, do not need to compile, can be compiled try)

http://blog.csdn.net/scutshuxue/article/details/5915689;

http://blog.itpub.net/29361362/viewspace-1062317/;

http://www.cnblogs.com/end/archive/2012/10/09/2717217.html;

http://blog.163.com/[email protected]/blog/static/13162315620118260333712/;

http://www.cnblogs.com/end/archive/2012/10/09/2717217.html;

Configuration of Hive in Hadoop