duckdb-r
duckdb-r copied to clipboard
duckdb
The duckdb R package
I am processing SQL statements and I don't know ahead of time whether the statement should be run using `dbExecute` or `dbGetQuery` so I am currently using `dbSendQuery` followed by...
Hello, I'm experimenting with DuckDB's spatial extension to unionize multiple large spatial datasets with polygon geometries. The datasets include a large number of different attributes, leading to a union query...
At present, there are two places where the database directory can be specified for a DuckDB database instance. Either in the **driver** or in the **connection** functions respectively. By having...
Getting the below error trying to use duckdb. Installation step: `install.packages("duckdb")` which then compiles duckdb try to run as per below ``` > con duckdb() Error: 'R_user_dir' is not an...
This addresses 2 issues: https://github.com/duckdb/duckdb-r/issues/118 and https://github.com/duckdb/duckdb-r/issues/383 col.types can be given as a named character vector providing the names and types of the columns such as: `col.types = c(col0 =...
I'm having a small issue when trying to install {duckdb} extensions on my Windows machine. I suspect this is because duckdb is pointing to a `http` url, instead of a...
Related to tidyverse/duckplyr#172 Add comparison expressions for duckdplyr
Here is a try for #142 @krlmlr: [You suggested](https://github.com/duckdb/duckdb-r/issues/142#issuecomment-2294792558) to modify the SQL and to use `tbl_function()`. I do not understand why it is needed. Cannot we just pass temporary...
Recently, in https://github.com/duckdb/duckdb-r/commit/27bba58e12d265527e0c64da97dd3ab63d2b2c8a, the R package for duckdb has been updated to normalize paths before connecting, using `normalizePath` with `mustWork = TRUE` However, `normalizePath` will fail on network drives if...
Currently, if `distinct` is used with `.keep_all = TRUE`, `ROW_NUMBER` is used. Which is normal `dbplyr` behavior for generics. But in my daily uses, I found `DISTINCT ON` is much...
