从R – windows 10连接到amazon redshift时出错

发布时间：2020-12-14 02:06:14 所属栏目：Windows 来源：网络整理

导读：当使用JDBC函数将R连接到amazon redshift时(我使用的是 Windows 10),我收到以下错误： Error in .jfindClass(as.character(driverClass)[1]) : class not found 我正在运行的代码是 install.packages("rJava")install.packages("RJDBC")library(rJava)librar

当使用JDBC函数将R连接到amazon redshift时(我使用的是 Windows 10),我收到以下错误：

Error in .jfindClass(as.character(driverClass)[1]) : class not found

我正在运行的代码是

install.packages("rJava")
install.packages("RJDBC")
library(rJava)
library(RJDBC)

download.file('http://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC41-1.1.13.1013.jar','RedshiftJDBC41-1.1.13.1013.jar')
driver <- JDBC("com.amazon.redshift.jdbc41.Driver","RedshiftJDBC41-1.1.13.1013.jar",identifier.quote = "`")

为了获得有关错误的更多信息,我运行了这个：

.jclassLoader()$setDebug(1L)

并且完整的错误跟踪是：

RJavaClassLoader: added 'RedshiftJDBC41-1.1.13.1013.jar' to the URL class path loader
RJavaClassLoader: adding Java archive file 'RedshiftJDBC41-1.1.13.1013.jar' to the internal class path
RJavaClassLoader: added 'C:/Users/user/Documents/R/win-library/3.2/RJDBC/java/RJDBC.jar' to the URL class path loader
RJavaClassLoader: adding Java archive file 'C:/Users/user/Documents/R/win-library/3.2/RJDBC/java/RJDBC.jar' to the internal class path
RJavaClassLoader@33909752.findClass(com.amazon.redshift.jdbc41.Driver)
 - URL loader did not find it: java.lang.ClassNotFoundException: com.amazon.redshift.jdbc41.Driver
RJavaClassLoader.findClass("com.amazon.redshift.jdbc41.Driver")
 - trying class path "C:UsersuserDocumentsRwin-library3.2rJavajava"
 Directory,can get 'C:UsersuserDocumentsRwin-library3.2rJavajavacomamazonredshiftjdbc41Driver.class'? NO
 - trying class path "C:UsersuserDocumentsRwin-library3.2RJDBCjavaRJDBC.jar"
JAR file,can get 'com/amazon/redshift/jdbc41/Driver'? NO
- trying class path "C:UsersuserDesktopPricing"
   Directory,can get 'C:UsersuserDesktopPricingcomamazonredshiftjdbc41Driver.class'? NO
- trying class path "C:UsersuserDesktopPricingRedshiftJDBC41-1.1.9.1009.jar"
JAR file,can get 'com/amazon/redshift/jdbc41/Driver'? NO
- trying class path "RedshiftJDBC41-1.1.9.1009.jar"
JAR file,can get 'com/amazon/redshift/jdbc41/Driver'? NO
- trying class path "." Directory,can get '.comamazonredshiftjdbc41Driver.class'? NO
- trying class path "C:RedshiftJDBC41-1.1.9.1009.jar"
JAR file,can get 'com/amazon/redshift/jdbc41/Driver'? NO
- trying class path "RedshiftJDBC41-1.1.13.1013.jar"
JAR file,can get 'com/amazon/redshift/jdbc41/Driver'? NO
>> ClassNotFoundException

如果您对某些可能有用的东西有任何想法,那就太棒了！谢谢

解决方法

我的建议是将redshift与RPostgreSQL包连接起来.

install.packages("RPostgreSQL")
library(RPostgreSQL)
drv <- dbDriver("PostgreSQL")
conn <-dbConnect(drv,host='host link',port='5439',dbname='dbname',user='xxx',password='yyy')
dbSendQuery(conn,"insert your query")

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!