duckdb-r
duckdb-r copied to clipboard
duckdb
The duckdb R package
What is the canonical way to write parquet to disk using duckdb and dbplyr without collecting first?
Scenario is working with very large (many GB) csv files and wanting to save them to parquet files after processing without reading/collecting them entirely into memory. I know how to...
Currently, the `timezone_out` and `tz_out_convert` options are supposed to convert date time columns with target timezones. But it is not converting any POSIXct columns. I think the problem is the...
If I run the following code: ```R library(duckdb) con
I cannot write a MAP type to a duckdb using `DBI::dbAppendTable()`. ```R con [1] 0 DBI::dbExecute(con, "INSERT INTO tbl VALUES (MAP {'a': 'b'})") #> [1] 1 DBI::dbGetQuery(con, "DESCRIBE tbl") #>...
This gives back a UTC time zone even if the original was in the local time zone. duckdb has an icu extension and TIMESTAMPTZ type which may solve this. Not...
https://github.com/duckdb/duckdb/discussions/12438#discussioncomment-9705955 suggested to ask this in this repo. Our team uses the tidyverse API and some basics statistics function in R for much of our data work. We have shifted...
Tried compiling v1.0.0 within R environment as part of installation and getting the following error. Installed the latest version of the re2 package without any issue, yet there seems to...
Previously in https://github.com/duckdb/duckdb/issues/12142 . Reproduced a similar outcome in clang-asan with: ```sh R -q -e 'pkgload::load_all(); con
``` r duckdb:::expr_constant(list(integer())) #> DuckDB Expression: [] ``` Created on 2024-06-24 with [reprex v2.1.0](https://reprex.tidyverse.org)
