우분투 16.04 mysql 설치

mysql 설치

$ sudo apt-get install software-properties-common

$ sudo add-apt-repository -y ppa:ondrej/mysql-5.5

$ sudo apt-get update

$ sudo apt-get install mysql-server

mysql 버전 확인

$ mysql --version

mysql 시작

$ systemctl start mysql

mysql 중지

$ systemctl stop mysql

mysql 접속

$ mysql -u root -p

mysql 접속 후 db보기

mysql> show databases;

////////////////////////////

           mysql> create database hive_metastore_db;

mysql> grant all privileges on *.* to 'hive'@'localhost' identified by 'hivedev' with grant option;

           mysql> grant all privileges on *.* to 'hive'@'%' identified by 'hivedev' with grant option;

           mysql> grant all privileges on hive_metastore_db.* to 'hive'@'%' identified by 'hivedev';

 

           mysql connector를 다운로드하여 HIVE_HOME/lib에 복사

           (http://www.mysql.com/downloads/connector/j/ 에서 다운로드하여 압축해제후 mysql-connector-java-5.1.41-bin.jar만 복사)

 

metastore 실행

           nohup hive --service metastore &

 

hiveserver2 실행 

           nohup hiveserver2 &

 

beeline 으로 접속

           beeline

           !connect jdbc:hive2://localhost:10000 hive hivedev

 

mysql 에서 생성된 테이블 확인

mysql -u hive -p

hivedev

show databases;

use hive_metastore_db

select * from tbls;

 

참고

http://www.gooper.com/ss/bigdata/271507

http://blog.csdn.net/roy_88/article/details/60884980

http://blrunner.com/100

https://cwiki.apache.org/confluence/display/Hive/AdminManual+Configuration

 

메타스토어 설정 방법

http://socurites.com/hadoop/%ED%95%98%EC%9D%B4%EB%B8%8Chive-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0