hadoop ecosystem/Hive
# hive > use kdatademo; create table mobilephones( id string, title string, cost float, colors array, screen_size array); INSERT INTO table mobilephones SELECT "galaxynote20", "galaxy note 20", 300, array("white","red","black"), array(float(4.5)) UNION ALL SELECT "iphone10", "iphone plus", 500, array("gold","black"), array(float(4.5), float(5.5)) > select * from mobilephones; > select title,colo..
Hive의 메타데이터를 저장하는 db를 durbyDB를 MySQL로 바꿀 예정 dn01에서 MariaDB실행 # mysql -u root -p 로 로그인 > grant all privileges on *.* to hive@"dn01" identified by "hive" with grant option; > use mysql >select user,host from user; >exit 1. dn01 노드의 root 계정에서 # cd /tmp # wget http://apache.mirror.cdnetworks.com/hive/hive-2.3.7/apache-hive-2.3.7-bin.tar.gz # tar xzvf apache-hive-2.3.7-bin.tar.gz # mkdir -p /opt/hive..