R 连 Hive 失败

63 views
Skip to first unread message

flyer

unread,
Sep 30, 2014, 12:02:47 AM9/30/14
to shlug
我目前用 hadoop-2.2.0 和 hive-0.12,想通过 R 连接 Hive,下面的是我在 Rstudio 中执行的操作:

library("DBI")
library("rJava")
library("RJDBC")
for(l in list.files('/PATH/TO/hive/lib/')){ .jaddClassPath(paste("/PATH/TO/hive/lib/",l,sep=""))}
for(l in list.files('/PATH/TO/hadoop/')){ .jaddClassPath(paste("/PATH/TO/hadoop/",l,sep=""))}
options( java.parameters = "-Xmx8g" )
drv <- JDBC("org.apache.hive.jdbc.HiveDriver", "/PATH/TO/hive/lib/hive-jdbc.jar")
conn <- dbConnect(drv, "jdbc:hive2://HOST:PORT", USER, PASSWD)

得到这样的错误信息:

Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1],  : 
  java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration

在网上查了下,没找到合适的解决方法。
请指点下,谢谢。

--
时光飞逝,但时光正好。

flyer

unread,
Sep 30, 2014, 1:25:47 AM9/30/14
to shlug
问题解决了,我把 hadoop 目录下所有的 jar 包都载入后就正常了……
--
时光飞逝,但时光正好。

arnk

unread,
Sep 30, 2014, 4:17:40 AM9/30/14
to shlug
一般NoClassDefFoundError就是jar包缺失。

--
-- You received this message because you are subscribed to the Google Groups Shanghai Linux User Group group. To post to this group, send email to sh...@googlegroups.com. To unsubscribe from this group, send email to shlug+un...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/shlug?hl=zh-CN
---
您收到此邮件是因为您订阅了Google网上论坛中的“Shanghai Linux User Group”论坛。
要退订此论坛并停止接收此论坛的电子邮件,请发送电子邮件到shlug+un...@googlegroups.com
要查看更多选项,请访问https://groups.google.com/d/optout



--
https://twitter.com/#!/arnkore
http://www.douban.com/people/arnk/
>>>
早已注定,我只能在荆棘中采拾鲜花。但重要的是,要对胜利和信念充满执着。
Reply all
Reply to author
Forward
0 new messages