安装hivemysql命令复习MySQL准备停止hdfs上传jar解压缩配置
复习mysql命令
systemctlstop/start/status/disable/enablefirewalld/mysqld
服务mysqld状态/开始/停止
检查网络端口是否正在使用
nenstat -nltp | grep 3306
mysql准备mysql -uroot -p登录
如果提示密码简单,请输入
mysqlsetglobalvalidate _ password _ policy=0;
mysqlsetglobalvalidate _ password _ length=4;
打开远程连接权限
grantallprivilegeson.to‘root’@“%”identified by‘root’withgrantoption;
没有5.6版本的密码直接访问mysql -uroot -p,enter可能会访问
更改密码use mysql
pdateusersetpassword=password (123456 ) ) WHERE user=‘root );
停止hdfs stop-dfs.sh
上传jar解压缩配置并重命名jar包: mv Apache-hive-3.1.2-yx dxs/hive-3.1.2
进入/opt/apps/hive-3.1.2/conf并重命名文件。 mv hive-env.sh.template hive-env.sh
设置vi hive-env.sh
写入:
导出Hadoop _ home=/opt/apps/Hadoop-3.1.1
export hive _ conf _ dir=/opt/apps/hive-3.1.2/conf
编辑vi hive-site.xml时没有自动创建
地址值的变更
组态! hive中记录的元数据信息记录在mysql中--property name javax.jdo.option.connection URL/namevaluejdbc : MySQL ://Linux 00000 use SSL=false/value/propertypropertynamejavax.jdo.option.connection drivername/name valuecom.MySQL.JDBC.drivername-- MySQL的用户名和密码--- property name javax.jdo.option.connection username/propertypropertynamejavax.property name javax namevalueroot/value/propertypropertynamehive.metastore.warehouse.dir/name value/user/hive/tmp/value/propertypropertynamehive.query log.location/name value/user/hive/log/value -客户端远程连接的端口--property name hive.server2. thrift.port/name value 10000/value/propertypropertynamehive propertypropertynamehive.server2. webui.host/name value0.0.0/value/property! -- hive服务页面上的端口----property name hive.server2. webui.port/name value 10002/value/propertypropertynamehive.sstyname propertypropertynamehive.server2. enable.doas/namevaluetrue/value/propertypropertynamedatanucleus.autocreeus propertypropertynamedatanucleus.fixed datastore/namevaluetrue/propertypropertynamehive.execution.engine/name mon -添加元数据服务配置--property name hive.metastore.local/namevaluefaluefe valuedescriptioncontrolswhethertoconnecttoremovemetastoreserveroropenanewmetastoreserverinhiveclientjvm/description/propertypropertynamehive.metastore.URIs/namevaluethrift ://Linux 00133609083/value/property/configuration