安装步骤
tongyuzhe3:服务端
tongyuzhe4:客户端
解压安装
修改环境变量
修改配置文件
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive_remote/warehouse</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://tongyuzhe1:3306/hive_remote?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive_remote/warehouse</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://tongyuzhe3:9083</value>
</property>
添加MySQL的驱动包拷贝到hive的lib目录
元数据库的初始化
schematool -dbType mysql -initSchema
启动hive的元数据服务
hive --service metastore
客户端操作