首页 > 数据库技术 > 详细

Hive-0.14.0版本，本地独立模式，MySQL作为元数据库

时间：2014-12-23 02:33:48      阅读：468      评论：0      收藏：0      [点我收藏+]

系统

Red hat linux 6.4

Hadoop版本

2.5.2

Hive版本

0.14.0

Mysql数据库版本

5.6.15

 
1.安装JDK，这个步骤在部署hadoop分布式集群时候已经操作过了，可以略过。

2.安装Mysql 数据库
     数据库的安装顺序
          (1)Mysql-server
          (2)mysql-client
          (3)启动mysql服务
          (4)用root用户登录，以授权方式创建hive元数据库，和hive用户
     grant all on hive.* to ‘hive‘@‘%‘ identified by ‘hive‘;  这个hive数据库，及其 用户和密码，是后面配置hive要用到的 ！！！
备注：Red Hat linux 下的mysql 安装 可参考 http://blog.itpub.net/28929558/viewspace-1192693/

3.部署Hive
（1）到官网下载hive http://mirror.bit.edu.cn/apache/hive/
（2）解压到自己需要的安装路径
（3）配置hive环境变量

点击(此处)折叠或打开

  1. #set hive_env
  2. export HIVE_HOME=/home/zhang/hive
  3. export PATH=$PATH:/home/zhang/hive/bin
  4. export CLASS_PATH=$CLASS_PATH:/home/zhang/hive/lib

（4）修改$HIVE_HOME/conf 下面配置文件(将需要配置的两个模板，拷贝重命名)

点击(此处)折叠或打开

  1. cp hive-env.sh.template hive-env.sh
  2. cp hive-default.xml.template hive-site.xml
（5）配置hive-env.sh 文件，指定 HADOOP_HOME

点击(此处)折叠或打开

  1. # Set HADOOP_HOME to point to a specific hadoop install directory
  2. HADOOP_HOME=/home/zhang/hadoop-2.5.2
（6）配置 hive-site.xml，指定MySQL数据库驱动、数据库名、用户名及密码，
修改的内容如下所示：

点击(此处)折叠或打开

  1. <property>
  2.   <name>javax.jdo.option.ConnectionURL</name>
  3.   <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
  4.   <description>JDBC connect string for a JDBC metastore</description>
  5. </property>


  8. <property>
  9.   <name>javax.jdo.option.ConnectionDriverName</name>
  10.   <value>com.mysql.jdbc.Driver</value>
  11.   <description>Driver class name for a JDBC metastore</description>
  12. </property>


  15. <property>
  16.   <name>javax.jdo.option.ConnectionUserName</name>
  17.   <value>hive</value>
  18.   <description>username to use against metastore database</description>
  19. </property>


  22. <property>
  23.   <name>javax.jdo.option.ConnectionPassword</name>
  24.   <value>hive</value>
  25.   <description>password to use against metastore database</description>
  26. </property>

  28. <property>
  29.   <name>hive.metastore.local</name>
  30.   <value>true</value>
  31.   <description></description>
  32. </property>
以上几个配置项，跟0.11.0版本没有区别，但是下面几个要注意配置下：
在hive下创建临时IO的tmp文件夹。然后将路径配置到下列参数中

点击(此处)折叠或打开

  1. <property>
  2.     <name>hive.querylog.location</name>
  3.     <value>/home/zhang/hive/iotmp</value>
  4.     <description>Location of Hive run time structured log file</description>
  5.   </property>
  6.   
  7.   <property>
  8.     <name>hive.exec.local.scratchdir</name>
  9.     <value>/home/zhang/hive/iotmp</value>
  10.     <description>Local scratch space for Hive jobs</description>
  11.   </property>
  12.   
  13.   <property>
  14.     <name>hive.downloaded.resources.dir</name>
  15.     <value>/home/zhang/hive/iotmp</value>
  16.     <description>Temporary local directory for added resources in the remote file system.</description>
  17.   </property>
备注如果不配置启动或操作hive时候会报错:

点击(此处)折叠或打开

  1. [zhang@namenode ~]$ hive
  2. 14/12/17 03:04:45 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
  3. 14/12/17 03:04:45 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist
  5. Logging initialized using configuration in jar:file:/home/zhang/hive/lib/hive-common-0.14.0.jar!/hive-log4j.properties
  6. SLF4J: Class path contains multiple SLF4J bindings.
  7. SLF4J: Found binding in [jar:file:/home/zhang/hadoop-2.5.2/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  8. SLF4J: Found binding in [jar:file:/home/zhang/hive/lib/hive-jdbc-0.14.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  9. SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  10. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
  11. Exception in thread \"main\" java.lang.RuntimeException: java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D
  12. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:444)
  13. at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:672)
  14. at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616)
  15. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  16. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  17. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  18. at java.lang.reflect.Method.invoke(Method.java:483)
  19. at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
  20. Caused by: java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D
  21. at org.apache.hadoop.fs.Path.initialize(Path.java:206)
  22. at org.apache.hadoop.fs.Path.<init>(Path.java:172)
  23. at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:487)
  24. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:430)
  25. ... 7 more
  26. Caused by: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D
  27. at java.net.URI.checkPath(URI.java:1823)
  28. at java.net.URI.<init>(URI.java:745)
  29. at org.apache.hadoop.fs.Path.initialize(Path.java:203)
  30. ... 10 more

（7）下载 mysql-connector-java-5.1.34-bin.jar 文件，并放到$HIVE_HOME/lib目录下 （到官网自行下载即可）
如果没有此jar包，启动hive会报如下错误：

点击(此处)折叠或打开

  1. Caused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver (\"com.mysql.jdbc.Driver\") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.
  2. at org.datanucleus.store.rdbms.connectionpool.AbstractConnectionPoolFactory.loadDriver(AbstractConnectionPoolFactory.java:58)
  3. at org.datanucleus.store.rdbms.connectionpool.BoneCPConnectionPoolFactory.createConnectionPool(BoneCPConnectionPoolFactory.java:54)
  4. at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:238)
  5. ... 66 more

至此，部署完毕，可以启动，测试下：
看到如下结果，说明启动成功

点击(此处)折叠或打开

  1. [zhang@namenode ~]$ hive
  2. 14/12/17 18:48:22 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
  3. 14/12/17 18:48:22 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist
  5. Logging initialized using configuration in jar:file:/home/zhang/hive/lib/hive-common-0.14.0.jar!/hive-log4j.properties
  6. SLF4J: Class path contains multiple SLF4J bindings.
  7. SLF4J: Found binding in [jar:file:/home/zhang/hadoop-2.5.2/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  8. SLF4J: Found binding in [jar:file:/home/zhang/hive/lib/hive-jdbc-0.14.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  9. SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  10. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
  11. hive> show tables;
  12. OK
  13. Time taken: 0.924 seconds
  14. hive> show databases;
  15. OK
  16. default
  17. Time taken: 0.051 seconds, Fetched: 1 row(s)

创建表测试：如果这部分没有报错，那么去检查HDFS下面是否生成了相关文件

点击(此处)折叠或打开

  1. hive> create table test(t_id int,t_name string) row format delimited fields terminated by \‘|\‘ stored as textfile;
  2. OK
  3. Time taken: 1.586 seconds
  4. hive> show tables;
  5. OK
  6. test
  7. Time taken: 0.078 seconds, Fetched: 1 row(s)
  8. hive> select * from test;
  9. OK
  10. Time taken: 0.599 seconds
检查HDFS是否生成相关文件：

点击(此处)折叠或打开

  1. [zhang@datanode01 ~]$ hdfs dfs -ls /
  2. 14/12/17 18:55:05 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
  3. Found 3 items
  4. drwxr-xr-x - zhang supergroup 0 2014-12-16 02:21 /input
  5. drwx-wx-wx - zhang supergroup 0 2014-12-17 01:25 /tmp
  6. drwxr-xr-x - zhang supergroup 0 2014-12-17 18:54 /user
  7. [zhang@datanode01 ~]$ hdfs dfs -ls /user/
  8. 14/12/17 18:55:20 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
  9. Found 1 items
  10. drwxr-xr-x - zhang supergroup 0 2014-12-17 18:54 /user/hive
  11. [zhang@datanode01 ~]$ hdfs dfs -ls /user/hive/
  12. 14/12/17 18:55:27 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
  13. Found 1 items
  14. drwxr-xr-x - zhang supergroup 0 2014-12-17 18:54 /user/hive/warehouse
  15. [zhang@datanode01 ~]$ hdfs dfs -ls /user/hive/warehouse/
  16. 14/12/17 18:55:34 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
  17. Found 1 items
  18. drwxr-xr-x - zhang supergroup 0 2014-12-17 18:54 /user/hive/warehouse/test
文件生成，至此验证完毕







Hive-0.14.0版本，本地独立模式，MySQL作为元数据库

原文：http://blog.itpub.net/28929558/viewspace-1371995/
踩
(0)
赞
(0)
   
举报
评论 一句话评论（0）
分享档案
更多>
2021年09月23日 (328)
2021年09月24日 (313)
2021年09月17日 (191)
2021年09月15日 (369)
2021年09月16日 (411)
2021年09月13日 (439)
2021年09月11日 (398)
2021年09月12日 (393)
2021年09月10日 (160)
2021年09月08日 (222)
最新文章
更多>
教程昨日排行
更多>
友情链接
汇智网   PHP教程   插件网  
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣，分享程序人生！