hive之远程模式环境搭建

1.解压与安装

sudo chmod 777 apache-hive-3.1.2-bin.tar.gz
sudo tar -zxvf apache-hive-3.1.2-bin.tar.gz -C  /home/hdfs/software
<!-- 修改名字为hive-3.1.2，并建立软链接-->
sudo mv apache-hive-3.1.2-bin hive-3.1.2
sudo ln -s hive-3.1.2  hive

2.配置环境变量

配置环境变量文件/etc/profile
sudo vi /etc/profile

export HIVE_HOME=/home/hdfs/software/hive
export PATH=$PATH:$HIVE_HOME/bin

最后source文件

source /etc/profile

3.拷mysql驱动到lib下

sudo cp /home/hdfs/mysql-connector-java-5.1.6.jar /home/hdfs/software/hive/lib

4.在conf目录下新建一个hive-site.xml

cd /home/hdfs/software/hive/conf
sudo 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:mysql://192.168.157.134:3306/metastore?useSSL=false</value>
    <description>
      JDBC connect string for a JDBC metastore.
      To use SSL to encrypt/authenticate the connection, provide database-specific SSL flag in the connection URL.
      For example, jdbc:postgresql://myhost/db?ssl=true for postgres database.
    </description>
</property>
 
 <property>
  <!--数据库驱动包-->
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
    <description>Driver class name for a JDBC metastore</description>
  </property>
 
  <property>
   <!--数据库用户名-->
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>root</value>
    <description>Username to use against metastore database</description>
  </property>
 
  <property>
  <!--数据库密码-->
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>root</value>
    <description>password to use against metastore database</description>
  </property>
 
  <property>
   <!--hdfs集群上对应的储存地址-->
    <name>hive.metastore.warehouse.dir</name>
    <value>/user/hive/warehouse</value>
    <description>location of default database for the warehouse</description>
  </property>

<property>
 <!--是否是本地模式，false-->
    <name>hive.metastore.local</name>
    <value>false</value>
</property>
<!--  <property>
    <name>hive.metastore.schema.verification</name>
    <value>false</value>
  </property>
 
  <property>
    <name>datanuclenus.schema.atuoCreateAll</name>
    <value>true</value>
  </property> -->

<!-- <property>
    <name>hive.metastore.uris</name>
    <value>thrift://192.168.157:9083</value>
  </property> -->

</configuration>

5.修改hive-env.sh文件

sudo cp hive-env.sh.template hive-env.sh

sudo vi hive-env.sh

引入hadoop_home和HIVE_CONF_DIR、HIVE_AUX_JARS_PATH

export HADOOP_HOME=/opt/hadoop
export HIVE_CONF_DIR=/home/hdfs/software/hive/conf

export HIVE_AUX_JARS_PATH=/home/hdfs/software/hive/lib

6.初始化元数据库

cd /home/hdfs/software/hive
./bin/schematool -dbType mysql -initSchema

7.mysql授权

serivce mysql start;
mysql -uroot -proot
grant all on *.* to hdfs@192.168.157.133 identified by 'root';
flush privileges ;

8.启动

cd /home/hdfs/software/hive
bin/hive