hive_快速搭建_1host

安装oracle客户端（选装）

【解压basic和sqlplus到同一目录】

• vi ~/.bash_profile

export ORACLE_HOME=$HOME/program/instantclient_11_2
export TNS_ADMIN=$ORACLE_HOME/NETWOEK/ADMIN
# export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LD_LIBRARY_PATH=$ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME

解压

echo 'export HIVE_HOME=$HOME/program/hive'
echo 'PATH=$PAHT:$HIVE_HOME/bin'

tar -xvf hive.tar
mv hive $HIVE_HOME

修改配置文件

cd $HIVE_HOME/conf
cp hive-default.xml.template hive-default.xml
vi hive-site.xml

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>
    <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <!--> <value>jdbc:oracle:thin:@10.10.10.10:1521:orcl</value></-->
        <value>jdbc:mysql://10.10.10.90:3306/hive?createDatabaseIfNotExist=truee&amp;useUnicode=true&amp;characterEncoding=utf8</value>
    </property>

    <property>
        <name>javax.jdo.option.ConnectionDriverName</name>
        <!--> <value>oracle.jdbc.OracleDriver</value></-->
        <value>com.mysql.jdbc.Driver</value>
    </property>

    <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>hive