hive
1)mysql安装
$sudo apt-get install mysql-server
登录mysql:$mysql -u root -p
建立数据库hive:mysql>create database hive;
mysql>show databases;//查看创建;
这里一定要把hive数据库的字符集修改为latin1,而且一定要在hive初次启动的时候就修改字符集 (否则就等着删除操作的时候死掉吧)
mysql>alter database hive character set latin1;
创建hive用户,并授权:mysql>grant all on hive.* to hive@'%' identified by 'hive';
(法二: DROP USER 'hive'@'%';
mysql> create user 'hive'@'%' identified by 'hive';
赋予权限 grant all privileges on *.* to 'hive'@'%' with grant option;
)
更新:mysql>flush privileges;
查询mysql的版本:mysql>select version();//这里是5.7.11-0ubuntu6
下载mysql的JDBC驱动包: http://dev.mysql.com/downloads/connector/j/
下载mysql-connector-java-5.1.38.tar.gz ,复制msyql的JDBC驱动包到Hive的lib目录下。