ropensci / ckanr

R client for the CKAN API
https://docs.ropensci.org/ckanr
Other
99 stars 38 forks source link

Translator is missing window variants of aggregate functions #188

Open fjuniorr opened 1 year ago

fjuniorr commented 1 year ago

Here is the message when we connect to a CKAN site with DataStore enabled and perform a query with a dplyr::collect call at the end:

library("ckanr"); library("dplyr")

ckan <- src_ckan("https://dados.mg.gov.br/")

resource <- tbl(src = ckan, name = "72d031e9-2753-469a-acfa-2d67417a2f49")

result <- resource |> 
          select(NUMERO_PROCESSO_COMPRA, VALOR_HOMOLOGADO) |> 
          collect()
#> Warning: Translator is missing window variants of the following aggregate functions:
#> * paste
#> Warning: Translator is missing window variants of the following aggregate functions:
#> * paste

The function translation vignette is available at Function translation • dbplyr.

Created on 2022-10-21 with reprex v2.0.2

Session Info and Traceback ```r sessionInfo() #> R version 4.2.1 (2022-06-23) #> Platform: x86_64-apple-darwin17.0 (64-bit) #> Running under: macOS Big Sur ... 10.16 #> #> Matrix products: default #> BLAS: /Library/Frameworks/R.framework/Versions/4.2/Resources/lib/libRblas.0.dylib #> LAPACK: /Library/Frameworks/R.framework/Versions/4.2/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] stats graphics grDevices utils datasets methods base #> #> other attached packages: #> [1] dplyr_1.0.10 ckanr_0.6.0 DBI_1.1.3 #> #> loaded via a namespace (and not attached): #> [1] Rcpp_1.0.9 compiler_4.2.1 pillar_1.8.1 dbplyr_2.2.1 #> [5] highr_0.9 tools_4.2.1 digest_0.6.29 jsonlite_1.8.1 #> [9] evaluate_0.16 lifecycle_1.0.2 tibble_3.1.8 pkgconfig_2.0.3 #> [13] rlang_1.0.6 reprex_2.0.2 cli_3.4.1 rstudioapi_0.14 #> [17] crul_1.3 curl_4.3.2 yaml_2.3.5 xfun_0.33 #> [21] fastmap_1.1.0 withr_2.5.0 stringr_1.4.1 knitr_1.40 #> [25] generics_0.1.3 fs_1.5.2 vctrs_0.4.2 triebeard_0.3.0 #> [29] tidyselect_1.1.2 glue_1.6.2 httpcode_0.3.0 R6_2.5.1 #> [33] fansi_1.0.3 rmarkdown_2.16 purrr_0.3.4 magrittr_2.0.3 #> [37] ellipsis_0.3.2 urltools_1.7.3 htmltools_0.5.3 assertthat_0.2.1 #> [41] utf8_1.2.2 stringi_1.7.8 ```