hrbrmstr / metis

Helpers for Accessing and Querying Amazon Athena using R, Including a lightweight RJDBC shim
Other
16 stars 2 forks source link

Error during connect #7

Open dkincaid opened 5 years ago

dkincaid commented 5 years ago

Just installed the package today since AWR.Athena is causing me too much grief. I'm getting the following error when trying to connect using

athenaConn <- RJDBC::dbConnect(metis::Athena(),
                        region = "us-east-1",
                        Schema = "cis.prod")
Error in .methodPackageSlots(def, label, table, dupl, isCurrent) : trying to get slot "target" from an object of a basic class ("environment") with no slots

7. .methodPackageSlots(def, label, table, dupl, isCurrent)
6. .cacheMethodInTable(fdef, sig, def, .getMethodsTable(fdef, ev, inherited = inherited))
5. cacheMethod(f, method@target, method, fdef = getGeneric(f), inherited = TRUE)
4. callNextMethod(drv, url = sprintf("jdbc:awsathena://athena.%s.amazonaws.com:443/", region), S3OutputLocation = S3OutputLocation, Schema = Schema, AWSCredentialsProviderClass = "com.simba.athena.amazonaws.auth.DefaultAWSCredentialsProviderChain", ...)
3. .local(drv, ...)
2. RJDBC::dbConnect(metis::Athena(), region = "us-east-1", Schema = "cis.prod")
1. RJDBC::dbConnect(metis::Athena(), region = "us-east-1", Schema = "cis.prod")

Using R 3.6.1

> sessionInfo()
R version 3.6.1 (2019-07-05)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Pop!_OS 19.04

Matrix products: default
BLAS:   /usr/lib/x86_64-linux-gnu/blas/libblas.so.3.8.0
LAPACK: /usr/lib/x86_64-linux-gnu/lapack/liblapack.so.3.8.0

locale:
 [1] LC_CTYPE=en_US.UTF-8          LC_NUMERIC=C                  LC_TIME=en_US.UTF-8           LC_COLLATE=en_US.UTF-8        LC_MONETARY=en_US.UTF-8      
 [6] LC_MESSAGES=en_US.UTF-8       LC_PAPER=en_US.UTF-8          LC_NAME=en_US.UTF-8           LC_ADDRESS=en_US.UTF-8        LC_TELEPHONE=en_US.UTF-8     
[11] LC_MEASUREMENT=en_US.UTF-8    LC_IDENTIFICATION=en_US.UTF-8

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
 [1] futile.logger_1.4.3  lazyeval_0.2.2       glue_1.3.1           dplyr_0.8.2          readr_1.3.1          DT_0.7               shinydashboard_0.7.1
 [8] openxlsx_4.1.0.1     aws.s3_0.3.12        shiny_1.3.2         

loaded via a namespace (and not attached):
 [1] zip_2.0.3            Rcpp_1.0.1           formatR_1.7          compiler_3.6.1       pillar_1.4.2         later_0.8.0          futile.options_1.0.1
 [8] RJDBC_0.2-7.1        base64enc_0.1-3      tools_3.6.1          digest_0.6.19        evaluate_0.14        jsonlite_1.6         tibble_2.1.3        
[15] pkgconfig_2.0.2      rlang_0.4.0          DBI_1.0.0            rstudioapi_0.10      crosstalk_1.0.0      curl_3.3             yaml_2.2.0          
[22] xfun_0.8             rJava_0.9-10         stringr_1.4.0        knitr_1.23           httr_1.4.0           xml2_1.2.0           sourcetools_0.1.7   
[29] htmlwidgets_1.3      hms_0.4.2            tidyselect_0.2.5     R6_2.4.0             rmarkdown_1.13       AWR.Athena_2.0.6-1   lambda.r_1.2.3      
[36] purrr_0.3.2          magrittr_1.5         promises_1.0.1       htmltools_0.3.6      shinythemes_1.1.2    assertthat_0.2.1     mime_0.7            
[43] aws.signature_0.5.0  xtable_1.8-4         httpuv_1.5.1         stringi_1.4.3        crayon_1.3.4     
hrbrmstr commented 5 years ago

Well met, @dkincaid!

Can you toss the output of sessionInfo()?

dkincaid commented 5 years ago

Yes, will do! Sorry about not including that originally.