Hive安装，

Hive安装，

1.修改hive-site.xml

<property>
  <name>hive.metastore.schema.verification</name>
  <value>false</value>
   <description>
   Enforce metastore schema version consistency.
   True: Verify that version information stored in metastore matches with one from Hive jars.  Also disable automatic
         schema migration attempt. Users are required to manully 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.
   </description>
</property>

否则报错

MetaException(message:Version information not found in metastore

虚拟机里面linux连接windows的mysql,要修改my.ini

#skip-network

去掉这个注释


新建远程登录用户

mysql -uroot -p
GRANT ALL PRIVILEGES ON*.* TO 'hive'@'%' Identified by 'hive';
GRANT ALL PRIVILEGES ON*.* TO 'hive'@'192.168.2.147' Identified by 'hive'
flush privileges;

重启mysql

mysqld stop
mysqls start

启动 hive

1.

sh hive --service metastore &

2.

sh hive --service hiveserver &

3.

sh hive