This repository has been archived by the owner on Jun 19, 2023. It is now read-only.
Using duckdb from R/arrowdrivermanager #5
paleolimbot
started this conversation in
Show and tell
Replies: 3 comments 2 replies
-
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 |
Beta Was this translation helpful? Give feedback.
0 replies
-
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 |
Beta Was this translation helpful? Give feedback.
0 replies
-
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? |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Based on @krlmlr's example in #3:
@nbenn @davidmli @lidavidm
Beta Was this translation helpful? Give feedback.
All reactions