Hello,
I have installed the AnnotationHub and loading the library does not show any errors, however, I get the error below when trying to run AnnotationHub function.
Please note that I can not upgrade to R 4.0 to re-install the latest version of the package, and instead tried to remove and downgrade dplyr and plyr packages which did not solve the problem. Is there any way that I can use AnnotationHub with R 3.6.3?
Thank You,
NF
library(AnnotationHub) # no errors created here
hub <- AnnotationHub() # error created here
Error in UseMethod("filter_") : no applicable method for 'filter_' applied to an object of class "c('tbl_SQLiteConnection', 'tbl_dbi', 'tbl_sql', 'tbl_lazy', 'tbl')"
sessionInfo( )
R version 3.6.3 (2020-02-29)
Platform: x86_64-apple-darwin15.6.0 (64-bit)
Running under: macOS Sierra 10.12.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/3.6/Resources/lib/libRlapack.dylib
locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8
attached base packages:
[1] parallel  stats4    stats     graphics  grDevices utils     datasets  methods   base     
other attached packages:
 [1] AnnotationHub_2.16.1 BiocFileCache_1.8.0  dplyr_1.0.2          plyr_1.8.6           dbplyr_2.0.0        
 [6] GenomicRanges_1.36.1 GenomeInfoDb_1.20.0  IRanges_2.18.3       S4Vectors_0.22.1     BiocGenerics_0.30.0 
loaded via a namespace (and not attached):
 [1] Rcpp_1.0.5                    later_1.1.0.1                 BiocManager_1.30.10           pillar_1.4.7                 
 [5] compiler_3.6.3                XVector_0.24.0                bitops_1.0-6                  tools_3.6.3                  
 [9] zlibbioc_1.30.0               digest_0.6.27                 bit_4.0.4                     RSQLite_2.2.1                
[13] memoise_1.1.0                 lifecycle_0.2.0               tibble_3.0.4                  pkgconfig_2.0.3              
[17] rlang_0.4.9                   shiny_1.5.0                   DBI_1.1.0                     rstudioapi_0.13              
[21] yaml_2.2.1                    curl_4.3                      fastmap_1.0.1                 GenomeInfoDbData_1.2.1       
[25] httr_1.4.2                    generics_0.1.0                vctrs_0.3.5                   rappdirs_0.3.1               
[29] bit64_4.0.5                   tidyselect_1.1.0              Biobase_2.44.0                glue_1.4.2                   
[33] R6_2.5.0                      AnnotationDbi_1.46.1          purrr_0.3.4                   blob_1.2.1                   
[37] magrittr_2.0.1                promises_1.1.1                htmltools_0.5.0               ellipsis_0.3.1               
[41] assertthat_0.2.1              xtable_1.8-4                  mime_0.9                      interactiveDisplayBase_1.22.0
[45] httpuv_1.5.4                  RCurl_1.98-1.2                crayon_1.3.4
                    
                
                
Thanks a lot for your reply. I was actually following that exact example, but to no avail. However, following your comment I went back and realized the reason was that there was a typo in there (marked below) that forwarded installation to the archive of dplyr package instead of dbplyr. After downgrading dbplyr it worked. Many Thanks!