I get an infinite hang in RStudio when I try to access data in my Presto database. This used to work fine (only a couple of months ago), but now it works only in R terminal and I am stumped as to why. I have tried a number of solutions related to R versions and paths but none work. I eventually have to kill RStudio to exit.
First, my session info is:
R version 4.0.0 (2020-04-24) Platform: x86_64-apple-darwin17.0 (64-bit) Running under: macOS Mojave 10.14.6 Matrix products: default BLAS: /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libBLAS.dylib LAPACK: /Library/Frameworks/R.framework/Versions/4.0/Resources/lib/libRlapack.dylib locale:  en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8 attached base packages:  stats graphics grDevices utils datasets methods base other attached packages:  dbplyr_1.4.3 RJDBC_0.2-8 rJava_0.9-12 DBI_1.1.0 loaded via a namespace (and not attached):  Rcpp_184.108.40.206 dplyr_0.8.5 crayon_1.3.4 assertthat_0.2.1 R6_2.4.1 lifecycle_0.2.0  magrittr_1.5 pillar_1.4.4 rlang_0.4.6 rstudioapi_0.11 vctrs_0.2.4 ellipsis_0.3.0  tools_4.0.0 glue_1.4.0 purrr_0.3.4 compiler_4.0.0 pkgconfig_2.0.3 tidyselect_1.0.0  tibble_3.0.1
The code I'm running works flawlessly in R terminal, but hangs for an infinite period when I run in RStudio. I'm just connecting to a Presto server (given an alias here).
I load the necessary packages here and initiate java.
library(DBI) require(RJDBC) library(dbplyr) library(dplyr) .jinit()
I specify the drivers here and the server config settings. Again, all works fine in R terminal.
drv <- JDBC("com.facebook.presto.jdbc.PrestoDriver", "/Users/me/Library/.../com.facebook.presto/presto-jdbc-0.224.jar", identifier.quote='"') presto <- dbConnect(drv, url = "jdbc:presto://presto-server:443/mydatabase/default?SSL=true", type="presto", user = "me", password = rstudioapi::askForPassword("Please enter your presto password"), schema = "")
Then, running the following code never completes and I have to force close RStudio:
tbl(presto, in_schema("source", "flatfiles")) %>% head()
I have tried:
- Making the paths between R terminal and RStudio identical
- Installing a new version of R (3.6->4.0)
- Starting RStudio in admin mode
Thanks in advance!