Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Not able to connect Imapa from R Console -- Need Help

Not able to connect Imapa from R Console -- Need Help

Explorer

Not able to connect Imapa from R Console:

 

Followed the steps as shown in - http://blog.cloudera.com/blog/2013/12/how-to-do-statistical-analysis-with-impala-and-r/

 

When i trying to connect impala-shell, it is connecting and i am able run any commands and able to see tables. But RImpala i am not able to, need suggetions.

 

My Ouputs:

 

> library(RImpala)
Loading required package: rJava

 

> rimpala.init(libs="/usr/lib/impala/lib/impala-jdbc-0.5-2/")
[1] "Classpath added successfully"

 

JDBC jars avaialble in /usr/lib/impala/lib/impala-jdbc-0.5-2/ are:

-rw-r--r-- 1 root root   38015 Feb  5  2013 commons-logging-1.0.4.jar
-rw-r--r-- 1 root root  116853 Feb  5  2013 hive-jdbc-0.10.0-cdh4.2.0.jar
-rw-r--r-- 1 root root 3083287 Feb  5  2013 hive-metastore-0.10.0-cdh4.2.0.jar
-rw-r--r-- 1 root root 1481780 Feb  5  2013 hive-service-0.10.0-cdh4.2.0.jar
-rw-r--r-- 1 root root  275186 Feb  5  2013 libfb303-0.9.0.jar
-rw-r--r-- 1 root root  347531 Feb  5  2013 libthrift-0.9.0.jar
-rw-r--r-- 1 root root  481535 Feb  5  2013 log4j-1.2.16.jar
-rw-r--r-- 1 root root   25962 Feb  5  2013 slf4j-api-1.6.4.jar
-rw-r--r-- 1 root root    9753 Feb  5  2013 slf4j-log4j12-1.6.1.jar

 

 

Tried below all options:

--------------------------

 rimpala.connect(IP="IP",port="21050")
Error: Could not establish connection to jdbc:hive2://IP:21050/;auth=noSasl: null
[1] FALSE

 

 

> rimpala.connect()
Error: Could not establish connection to jdbc:hive2://localhost:21050/;auth=noSasl: null
[1] FALSE

 

 

 

When i trying to connect impala-shell, it is connecting and i am run any commands and able to see tables.

 

 

Thanks- :-(

 

1 REPLY 1

Re: Not able to connect Imapa from R Console -- Need Help

Master Collaborator

We suggest that you contact the developers of RImpala directly:

http://cran.r-project.org/web/packages/RImpala/index.html