duckplyr

duckplyr copied to clipboard

Filter pushdown discrepancy between duckdb and duckplyr

7

This issue is related to the discussion in this comment: The following code demonstrates the difference in filter pushdown between DuckDB and Duckplyr as shown by the `explain()` function. With...

PMassicotte

detect r_base::aggregate::

1

Based on https://github.com/hannes/duckdb-rfuns/pull/95 aka https://github.com/duckdb/duckdb-r/pull/169

romainfrancois

difference between `duckplyr` and `dbplyr`?

12

I find it quite convenient to use `duckdb` as a backend of `dplyr` (through `dbplyr`). All you need to do is to specify a `duckdb` connection, and read data through...

ywhcuhk

Need to be stricter about column compatibility in joins

3

Also, use simple identity instead of `r_base::==` for joins. ``` r dplyr::union_all(data.frame(a = 1), data.frame(a = "2")) #> Error in `dplyr::union_all()`: #> ! `x` and `y` are not compatible. #>...

krlmlr

[Question] Best Practices for changing DuckDB Settings

5

Hi all, thanks for developing such a fantastic package! I frequently have to change configuration settings for DuckDB in order to get my queries to run, and am writing to...

beniaminogreen

duckplyr does not support lubridate

2

duckdb when used with dbplyr supports the use of lubridate. However duckplyr does not. It would be nice for duckplyr to have this capability i suspect. ``` r library(duckdb) library(dplyr)...

JosiahParry

Currently it's not clear which functions are supported/available within the package. As a concrete example, the functions `wday()` and `hour()` both work but, as they are not part of dplyr,...

TimTaylor

From the rWCVP package. Ideally, we would detect that `scientificName` is not used in the query, and never even load it into duckdb. ``` r lhs --------------------- #> --- Relation...

krlmlr

Fix descending sort for character data

4

``` r options(conflicts.policy = list(warn = FALSE)) library(duckplyr) Sys.setenv("DUCKPLYR_FORCE" = "TRUE") data.frame(a = letters[1:3]) |> as_duckplyr_df() |> arrange(desc(a)) #> Error: Binder Error: No function matches the given name and argument...

krlmlr

Use the following `Dockerfile` to investigate again: ```Dockerfile FROM ghcr.io/cynkra/rig-ubuntu-duckdb:main RUN R -q -e 'pak::pak("krlmlr/dplyr@f-revdep-duckplyr", upgrade = TRUE)' RUN R -q -e 'pak::pak(c("msigdbr", "mtdesign", "partition", "rfars"), dependencies = TRUE)' RUN...

krlmlr