deleted deleted

deleted deleted   •   over 7 years ago

Connect to Biginsight from desktop RStudio

Hello,

I triy to connect to Biginsight from desktop RStudio. I follow these instructions: https://www.ibm.com/developerworks/community/blogs/a4hblogs/entry/how_to_connect_to_analytics_for_hadoop_bigr_from_local_rstudio?lang=en

Unfortunatelly I can't do the 6. steps. In Biginsight the connection works but in Rstudio doesn't. My parameteres are:

bigr.connect(host="bi-hadoop-prod-365.services.dal.bluemix.net", 7052, "default", user="biblumix", password="xxmypasswordxx")
Error: BigR[bigr.connect]: Connection could not be established. Verify connection parameters.

What could be wrong?

Thanks!

  • 4 comments

  •   •   over 7 years ago

    Try stoping and restarting the BIg SQL scheduler on the big insights cluster tab. I had the same issue and this worked.

  •   •   over 7 years ago

    It takes several minutes for the service to get back up and running after stopping. Make sure it is running before trying to connect through R Studio.

  •   •   over 7 years ago

    Hi Melinda, I was able to connect to your cluster from local RStudio. Make sure you enter the correct biblumix password from your A4H service page.
    > library(bigr)
    Loading required package: rJava
    > bigr.connect(host="bi-hadoop-prod-365.services.dal.bluemix.net", 7052, "default", user="biblumix", password="ReplaceWithBiblumixPasswordOnA4HPage")
    > is.bigr.connected()
    [1] TRUE
    >

  •   •   over 7 years ago

    Hi Melinda, Can you please try these steps :
    1. Make sure Oracle Java 7 is set in your JAVA_HOME and path. What Java version do you use ? Please try with Oracle Java 7. Also , ensure that its 64 bit or 32 bit Java pertaining to your environment. As the stackoverflow link states , you can set JAVA_HOME inside R in the following way
    Sys.setenv(JAVA_HOME="C:\\Program Files\\Java\\jre7\\")
    Or
    options(java.home="C:\\Program Files\\Java\\jre7\\")
    library(rJava)
    2. One more thing : please make sure the underlying R in your environment is either 32 bit or 64 bit and not both. If you have installed for both, uninstall R and then re-install only one.
    Hope this helps and let me know .

Comments are closed.