Using duckdb from R/arrowdrivermanager

[paleolimbot]

Based on @krlmlr's example in #3:

library(adbcdrivermanager)

drv <- adbc_driver(
  asNamespace("duckdb")$.__NAMESPACE__.$DLLs$duckdb[["path"]],
  "duckdb_adbc_init"
)

db <- adbc_database_init(drv)

read_adbc(db, "SELECT 1;") |> 
  tibble::as_tibble()
#> # A tibble: 1 × 1
#>     `1`
#>   <int>
#> 1     1

@nbenn @davidmli @lidavidm

[krlmlr]

Thanks. Not on my machine:

library(adbcdrivermanager)

packageVersion("duckdb")
#> [1] '0.8.0'

drv <- adbc_driver(
  asNamespace("duckdb")$.__NAMESPACE__.$DLLs$duckdb[["path"]],
  "duckdb_adbc_init"
)
#> Error in adbc_driver(asNamespace("duckdb")$.__NAMESPACE__.$DLLs$duckdb[["path"]], : <RAdbcLoadDriver()> dlsym(duckdb_adbc_init) failed: dlsym(0x93f81f70, duckdb_adbc_init): symbol not found

db <- adbc_database_init(drv)
#> Error in adbc_database_init(drv): object 'drv' not found

read_adbc(db, "SELECT 1;") |>
  tibble::as_tibble()
#> Error in read_adbc(db, "SELECT 1;"): object 'db' not found

^{Created on 2023-06-07 with reprex v2.0.2}

[paleolimbot]

How is DuckDB installed/what version? I just did a fresh CRAN install (I'm on M1 Mac) and I have duckdb 0.8:

sessioninfo::session_info("duckdb")
#> ─ Session info ───────────────────────────────────────────────────────────────
#>  setting  value
#>  version  R version 4.2.1 (2022-06-23)
#>  os       macOS Ventura 13.4
#>  system   aarch64, darwin20
#>  ui       X11
#>  language (EN)
#>  collate  en_US.UTF-8
#>  ctype    en_US.UTF-8
#>  tz       America/Halifax
#>  date     2023-06-07
#>  pandoc   2.19.2 @ /Applications/RStudio.app/Contents/Resources/app/quarto/bin/tools/ (via rmarkdown)
#> 
#> ─ Packages ───────────────────────────────────────────────────────────────────
#>  package * version date (UTC) lib source
#>  DBI       1.1.3   2022-06-18 [1] CRAN (R 4.2.0)
#>  duckdb    0.8.0   2023-05-23 [1] CRAN (R 4.2.0)
#> 
#>  [1] /Library/Frameworks/R.framework/Versions/4.2-arm64/Resources/library
#> 
#> ──────────────────────────────────────────────────────────────────────────────

^{Created on 2023-06-07 with reprex v2.0.2}

[krlmlr]

I had duckdb installed from source. Now installed as binary from CRAN, seeing:

library(adbcdrivermanager)

packageVersion("duckdb")
#> [1] '0.8.0'

drv <- adbc_driver(
  asNamespace("duckdb")$.__NAMESPACE__.$DLLs$duckdb[["path"]],
  "duckdb_adbc_init"
)

db <- adbc_database_init(drv)

read_adbc(db, "SELECT 1;") |>
  tibble::as_tibble()
#> Error in adbc_stream_join(stream, stmt): adbc_stream_join_statement() requires nanoarrow >= 0.2.0

^{Created on 2023-06-07 with reprex v2.0.2}

Where do I get that nanoarrow version?

[paleolimbot]

Ah, sorry. nanoarrow 0.2 is coming soon too! remotes::install_github("apache/arrow-nanoarrow", build = FALSE) is the most reliable way.

[krlmlr]

Thanks, I forgot to pull 🤦