Hive-0.13.1本地独立模式安装 元数据存储到MariaDB-10.1.0 Hadoop-2.4.0,
http://xiejianglei163.blog.163.com/blog/static/1247276201462491813826/
使用的Hadoop版本:2.4.0
离线安装MariaDB: http://xiejianglei163.blog.163.com/blog/static/124727620144541845753/
安装完后查看mariadb状态: service mysql status service mysql start 修改root密码: mysqladmin -u root password 'root' 登录: mysql -u root -p
创建用户 :
- MariaDB [(none)]>insert into mysql.user(Host,User,Password) values("localhost","hadoop",password("hadoop"));
- MariaDB [(none)]>flush privileges;
安装Hive,解压: tar -zxvf apache-hive-0.13.1-bin.tar.gz
解压后,编辑java.sh(java.sh为自己创建的脚本): vim /etc/profile.d/java.sh export HIVE_HOME=/opt/modules/hive/apache-hive-0.13.1-bin export HIVE_CONF_DIR=$HIVE_HOME/conf export CLASSPATH=$CLASSPATH:$HIVE_HOME/lib 并将$HIVE_HOME/bin加入到PATH中
下载java的驱动包: mariadb-java-client-1.1.7.jar 放到$HIVE_HOME/lib下面
复制hive-default.xml.template为hive-site.xml并编辑: <property>
<name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true</value> <description>JDBC connect string for a JDBC metastore</description></property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name> <value>org.mariadb.jdbc.Driver</value> <description>Driver class name for a JDBC metastore</description></property>
<property>
<name>javax.jdo.option.ConnectionUserName</name> <value>hadoop</value> <description>username to use against metastore database</description></property>
<property>
<name>javax.jdo.option.ConnectionUserName</name> <value>hadoop</value> <description>username to use against metastore database</description></property>
<property>
<name>javax.jdo.option.ConnectionPassword</name> <value>hadoop</value> <description>password to use against metastore database</description></property>
<property>
<name>hive.metastore.warehouse.dir</name> <value>hdfs://master:9000/user/hive/warehouse</value> <description>location of default database for the warehouse</description></property>
命令:hive hive>show tables; create table xjl(id int); drop table xjl;
查看MariaDB中的hive可以看到出现了许多张表
Hive的数据存放在hdfs中/user/hive/warehouse中
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。