Open
Description
I might be jumping the gun here, given that the DuckLake core extension has only just been announced. But in case this is helpful:
I tried to run the usage example from the DuckLake release announcement using the duckdb (version 1.3.0.9000) R package (installed from R-universe).
I was able to install the extension, attach a ducklake and insert data into it:
library(duckdb)
con <- dbConnect(duckdb())
dbExecute(
con,
"INSTALL ducklake;
ATTACH 'ducklake:metadata.ducklake' AS my_ducklake (DATA_PATH 'data_files');
USE my_ducklake;
CREATE TABLE my_ducklake.demo (i INTEGER);
INSERT INTO my_ducklake.demo VALUES (42), (43);")But I haven't figured out how to read the table, yet:
dbGetQuery(con, "FROM my_ducklake.demo;")fails with
DuckDB progress: 0%Error in `duckdb_result()`:
! rapi_execute: Failed to run query
Error: Not implemented Error: Scanning a DuckLake table after the transaction has ended - this use case is not yet supported
Is that expected / a known limitation? Or perhaps I am not issuing the command correctly?
Thanks for giving R-users such a great tool! ❤
Session Information
> sessionInfo()
R version 4.4.3 (2025-02-28)
Platform: aarch64-apple-darwin20
Running under: macOS Sequoia 15.5
Matrix products: default
BLAS: /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libBLAS.dylib
LAPACK: /Library/Frameworks/R.framework/Versions/4.4-arm64/Resources/lib/libRlapack.dylib; LAPACK version 3.12.0
locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8
time zone: America/Los_Angeles
tzcode source: internal
attached base packages:
[1] stats graphics grDevices datasets utils methods base
other attached packages:
[1] duckdb_1.3.0.9000 DBI_1.2.3
loaded via a namespace (and not attached):
[1] compiler_4.4.3 cli_3.6.5 tools_4.4.3 pillar_1.10.2 glue_1.8.0 yaml_2.3.10
[7] vctrs_0.6.5 lifecycle_1.0.4 rlang_1.1.6 renv_1.1.4
Metadata
Metadata
Assignees
Labels
No labels