1

I tried to use the code from this link but I got an error

driver <- JDBC("com.amazon.redshift.jdbc41.Driver", "RedshiftJDBC41-1.1.9.1009.jar", identifier.quote="`") JavaVM: requested Java version ((null)) not available. Using Java at "" instead. JavaVM: Failed to load JVM: /bundle/Libraries/libserver.dylib JavaVM FATAL: Failed to load the jvm library. Error in .jinit(classPath) : JNI_GetCreatedJavaVMs returned -1

After loading the driver and trying to connect. I don't know how to connect Redshift to R.

epo3
  • 2,991
  • 2
  • 33
  • 60
ashwanth s
  • 41
  • 1
  • 6

1 Answers1

2

This will not solve the error, but if you want to connect to Redshift from R, you can use RPostgreSQL library. as in the answer in another R-Redshift connection issue

library (RPostgreSQL)
drv <- dbDriver("PostgreSQL")
conn <- dbConnect(drv, host="your.host.us-east-1.redshift.amazonaws.com", 
             port="5439",
             dbname="your_db_name", 
             user="user", 
             password="password")

You also need to make sure that your IP is Redshift security group white list.

Community
  • 1
  • 1
haimco
  • 100
  • 1
  • 7