Hadoop环境配置之hive环境配置详解

 cd /opt/software/ tar -zxvf 压缩包名 -C /opt/module/

 vi /etc/profile

 export HIVE_HOME=/opt/module/apache-hive-3.1.2-bin export PATH=$PATH:$HADOOP_HOME/sbin:$HIVE_HOME/bin

 source /etc/profile

 cd  /opt/module/apache-hive-3.1.2-bin/bin/

 vi hive-config.sh

 export JAVA_HOME=/opt/module/jdk1.8.0_212 export HIVE_HOME=/opt/module/apache-hive-3.1.2-bin export HADOOP_HOME=/opt/module/hadoop-3.2.0 export HIVE_CONF_DIR=/opt/module/apache-hive-3.1.2-bin/conf

 cd  /opt/module/apache-hive-3.1.2-bin/conf/ cp hive-default.xml.template hive-site.xml

 vi hive-site.xml

     javax.jdo.option.ConnectionDriverNamecom.mysql.cj.jdbc.DriverDriver class name for a JDBC metastore javax.jdo.option.ConnectionUserNamerootUsername to use against metastore database javax.jdo.option.ConnectionPassword123456 # 自定义密码 password to use against metastore database javax.jdo.option.ConnectionURLjdbc:mysql://192.168.1.100:3306/hive?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT 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.  datanucleus.schema.autoCreateAlltrueAuto creates necessary schema on a startup if one doesn't exist. Set this to false, after creating it once.To enable auto create also set hive.metastore.schema.verification=false. Auto creation is not recommended for production use cases, run schematool command instead. hive.metastore.schema.verificationfalse Enforce metastore schema version consistency. True: Verify that version information stored in is compatible with one from Hive jars.  Also disable automatic schema migration attempt. Users are required to manually migrate schema after Hive upgrade which ensures proper metastore schema migration. (Default) False: Warn if the version information stored in metastore doesn't match with one from in Hive jars.  hive.exec.local.scratchdir/opt/module/apache-hive-3.1.2-bin/tmp/${user.name}Local scratch space for Hive jobs system:java.io.tmpdir/opt/module/apache-hive-3.1.2-bin/iotmp hive.downloaded.resources.dir/opt/module/apache-hive-3.1.2-bin/tmp/${hive.session.id}_resourcesTemporary local directory for added resources in the remote file system. hive.querylog.location/opt/module/apache-hive-3.1.2-bin/tmp/${system:user.name}Location of Hive run time structured log file hive.server2.logging.operation.log.location/opt/module/apache-hive-3.1.2-bin/tmp/${system:user.name}/operation_logsTop level directory where operation logs are stored if logging functionality is enabled hive.metastore.db.typemysql Expects one of [derby, oracle, mysql, mssql, postgres]. Type of database used by the metastore. Information schema & JDBCStorageHandler depend on it.  hive.cli.print.current.dbtrueWhether to include the current database in the Hive prompt. hive.cli.print.headertrueWhether to print the names of the columns in query output. hive.metastore.warehouse.dir/opt/hive/warehouselocation of default database for the warehouse

 mysql> create database hive;

 schematool -dbType mysql -initSchema

 start-all.sh    Hadoop100上 start-yarn.sh    Hadoop101上

 hive

 show databases;