duckdb-r
duckdb-r copied to clipboard
duckdb
The duckdb R package
Closes #155. We'd need to either upstream this, or patch here. Unclear about the consequences. ``` r duckdb -- Result Columns -- #> --------------------- #> - a (DOUBLE) #> -...
PR includes following changes: - move DBI from Depends to Imports in DCF: It is good practice to avoid Depends when possible in favor of Imports. Side effect is that...
The duckdb engine assumes all strings are valid utf-8. In the R-client, we forgot to check if strings were in fact utf8. Here we check them when the scanning the...
``` > con dbGetQuery(con, "SELECT map([1,2],['a','b']) AS x;") Error: rapi_prepare: Unknown column type for prepare: MAP(INTEGER, VARCHAR) ```
From duckdb/duckdb#6771 It is convenient in the Python client to specify the target of a query without having to register `pandas.DataFrame`, etc., so it would be nice to have the...
Now that the pr for some clock functions has been merged in https://github.com/tidyverse/dbplyr/pull/1496, there is another function I think is particularly useful for analytics: [date_count_between](https://clock.r-lib.org/reference/date_count_between.html) @krlmlr would you happy for...
This issue arises from my question [in Mastodon](https://fosstodon.org/@florisvdh/112401703483569145) and the answer by @krlmlr. For DBI to take full advantage of Arrow support in DuckDB, e.g. if the DuckDB table has...
``` rfuns.cpp: In function 'int32_t duckdb::rfuns::{anonymous}::cast(T, duckdb::ValidityMask&, duckdb::idx_t) [with T = double; int32_t = int; duckdb::idx_t = long long unsigned int]': rfuns.cpp:111:13: error: 'isnan' was not declared in this scope;...
