Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

R-Impala connect prompts FALSE Error: null #10

Open
HOHOOO opened this issue Jun 27, 2016 · 2 comments
Open

R-Impala connect prompts FALSE Error: null #10

HOHOOO opened this issue Jun 27, 2016 · 2 comments

Comments

@HOHOOO
Copy link

HOHOOO commented Jun 27, 2016

Trying to connect R with Impala through Rimpala package, not sure what am I doing wrong here.

In short, got installed:

JDK of compatible version,
native JBDC .jar files placed to java's CLASSPATH
Impala is up and running,
First command went well:
rimpala.init(impala_home=NULL,libs="/path/...") - "Classpath added succesfully"
however connection fails at the second step:

rimpala.connect(IP="localhost",port="21050")
[1] FALSE
Error: null
Many thanks

@burakongun
Copy link

Hello, I'm having the same problem. Have you been able to solve this issue?

@HOHOOO
Copy link
Author

HOHOOO commented Dec 19, 2016

finally, I use this:
library(RJDBC)
drv <- JDBC(driverClass = "org.apache.hive.jdbc.HiveDriver",classPath = list.files("/home/drivers/impala-jdbc-0.5-2",pattern="jar$",full.names=T,recursive=T),identifier.quote="`")
conn <- dbConnect(drv, "jdbc:hive2://localhost:21050/;auth=noSasl")
month.data <- dbGetQuery(conn, "select * from brand_model_sum order by how_many limit 5")
dbDisconnect(conn)
you can try it for yourself.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants