Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to install, configure and use Hive. It is very detailed and has a certain reference value. Friends who are interested must finish reading it.

10. Hive

This topic describes the installation, configuration, and basic use of Hive.

Hive basic Information

Official website: http://hive.apache.org/10.1. Environment preparation # switch to workspace cd / opt/workspaces# to create Hive data directory mkdir data/hive# create Hive log directory mkdir logs/hive10.2. Install wget http://mirrors.cnnic.cn/apache/hive/hive-1.2.1/apache-hive-1.2.1-bin.tar.gztar-zxf apache-hive-1.2.1-bin.tar.gzrm-rf apache-hive-1.2.1-bin.tar.gzmv apache-hive-1.2.1-bin. / frameworks/hive10.3. Configuration (stand-alone)

Vi / .profile

Export HIVE_HOME=/opt/workspaces/frameworks/hiveexport PATH=$PATH:$HIVE_HOME/binsource / .profile

Configure Mysql

Mysql-u root-pcreate database hive;grant all on *. * to'hive'@'%' identified by 'hive'; # account hive, password hive, all IP can access (%) flush privileges;exit

Create a HDFS directory

. / frameworks/hadoop/bin/hadoop fs-mkdir / tmp./frameworks/hadoop/bin/hadoop fs-mkdir-p / user/hive/warehouse./frameworks/hadoop/bin/hadoop fs-chmod 777 / tmp./frameworks/hadoop/bin/hadoop fs-chmod 777 / user/hive/warehouse

Modify Hive configuration

Cat >. / frameworks/hive/conf/hive-env.shtest_person.txt

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.