Hive 0.13.1 on Hadoop2.2.0 + Oracle10g deployment details
Environment: Hadoop2.2.0hive0.13.1Ubuntu 14.04 LTSjava version "1.7.0 _ 60" Oracle10g
Download the installation package http://mirrors.cnnic.cn/apache/hive/stable/apache-hive-0.13.1-bin.tar.gz at the address below Unzip the installation package to/home/fulong/Hive/apache-hive-0.13.1-bin on the server. Modify the environment variable and add the following content: export HIVE_HOME =/home/fulong/Hive/apache-hive-0.13.1-binexport PATH = $ HIVE_HOME/bin: $ PATH Copy the template configuration file to the conf directory and rename fulong @ FBI006 :~ /Hive/apache-hive-0.13.1-bin/conf $ lshive-default.xml.template hive-exec-log4j.properties.templatehive-env.sh.template Co., hive-log4j.properties.templatefulong @ FBI006 :~ /Hive/apache-hive-0.13.1-bin/conf $ cp hive-env.sh.template hive-env.shfulong @ FBI006 :~ /Hive/apache-hive-0.13.1-bin/conf $ cp hive-default.xml.template hive-site.xmlfulong @ FBI006 :~ /Hive/apache-hive-0.13.1-bin/conf $ lshive-default.xml.template hive-env.sh.template hive-log4j.properties.templatehive-env.sh hive-exec-log4j.properties.template hive-site.xml Modify the following in the configuration file hive-env.sh to specify the Hadoop root directory, hive conf and lib Directory # Set HADOOP_HOME to point to a specific hadoop install directoryHADOOP_HOME =/home/fulong/Hadoop/hadoop-2.2.0 # Hive Configuration Directory can be controlled: export HIVE_CONF_DIR =/home/fulong/Hive/apache-hive-0.13.1-bin/conf # Folder containing extra ibraries required for hive compilation/execution can be controlled: export HIVE_AUX_JARS_PATH =/home/fulong/Hive/apache-hive-0.13.1-bin/lib Modify the following Oracle-related parameters in the configuration file hive-site.sh <property> <name> javax. jdo. option. ConnectionURL </name> <value>