Repository navigation
fromDataFrame() fails to ingest dense array when setting dim index #898
Description
Now that #877 is fixed by #896 , the following issue is much easier to deal with:
NOTE: dev r-tiledb 0.34.0.1
CASE 1: schema creation, seta column index and ingests
library(tiledb)
uri <- tempfile()
df1 <- data.frame(index = 1:2,
a = c(100, 120),
b = c(80, 120))
# FAIL
tiledb::fromDataFrame(df1,
uri,
col_index = 1,
sparse = FALSE,
mode = "ingest")
#> Error:
#> ! [TileDB::Query] Error: Unordered writes are only possible for sparse arraysCASE 2: schema creation, no column index and ingest
# OK
uri <- tempfile()
tiledb::fromDataFrame(df1,
uri,
col_index = NULL, # an index column is added when the array is created
sparse = FALSE,
mode = "ingest")
arr <- tiledb_array(uri, return_as = "data.frame")
arr[]
#> __tiledb_rows index a b
#> 1 1 1 100 80
#> 2 2 2 120 120CASE 3: "schema_only" then ingest via [ method
# OK
uri <- tempfile()
tiledb::fromDataFrame(df1,
uri,
col_index = 1,
sparse = FALSE,
mode = "schema_only")
arr <- tiledb_array(uri, return_as = "data.frame")
arr[1:2, ] <- df1[, -1]
arr[]
#> index a b
#> 1 1 100 80
#> 2 2 120 120Created on 2026-10-27 with reprex v2.1.1
Session info
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#> setting value
#> version R version 4.6.1 (2026-06-24)
#> os Ubuntu 24.04.5 LTS
#> system x86_64, linux-gnu
#> ui X11
#> language (EN)
#> collate en_US.UTF-8
#> ctype en_US.UTF-8
#> tz Etc/UTC
#> date 2026-10-27
#> pandoc 3.12.1 @ /usr/bin/ (via rmarkdown)
#> quarto 1.10.18 @ /usr/local/bin/quarto
#>
#> ─ Packages ───────────────────────────────────────────────────────────────────
#> package * version date (UTC) lib source
#> bit 4.6.0 2025-03-06 [1] RSPM
#> bit64 4.8.6 2026-09-01 [1] RSPM
#> cli 3.6.6 2026-04-09 [1] RSPM
#> data.table 1.18.6.1 2026-08-24 [1] RSPM
#> digest 0.6.39 2025-11-19 [1] RSPM
#> evaluate 1.0.5 2025-08-27 [1] RSPM
#> fastmap 1.2.0 2024-05-15 [1] RSPM
#> fs 2.1.0 2026-04-18 [1] RSPM
#> glue 1.8.1 2026-04-17 [1] RSPM
#> htmltools 0.5.9 2025-12-04 [1] RSPM
#> knitr 1.52 2026-09-06 [1] RSPM
#> lattice 0.22-9 2026-02-09 [2] CRAN (R 4.6.1)
#> lifecycle 1.0.5 2026-01-08 [1] RSPM
#> nanoarrow 0.9.0 2026-08-04 [1] RSPM (R 4.6.0)
#> nanotime 0.3.15 2026-05-21 [1] RSPM
#> otel 0.2.0 2025-08-29 [1] RSPM
#> pillar 1.11.1 2025-09-17 [1] RSPM
#> Rcpp 1.1.2 2026-07-05 [1] RSPM
#> RcppCCTZ 0.2.14 2026-01-08 [1] RSPM (R 4.6.0)
#> RcppSpdlog * 0.0.29 2026-05-09 [1] RSPM (R 4.6.0)
#> reprex 2.1.1 2024-07-06 [1] RSPM
#> rlang 1.3.0 2026-07-05 [1] RSPM
#> rmarkdown 2.32 2026-09-01 [1] RSPM
#> rstudioapi 0.19.0 2026-06-11 [1] RSPM
#> sessioninfo 1.2.4 2026-06-04 [1] RSPM
#> spdl 0.0.5 2023-06-18 [1] RSPM (R 4.6.0)
#> tiledb * 0.34.0.1 2026-10-27 [1] Github (TileDB-Inc/TileDB-R@9812fc4)
#> vctrs 0.7.3 2026-04-11 [1] RSPM
#> withr 3.0.3 2026-06-19 [1] RSPM
#> xfun 0.62 2026-10-16 [1] RSPM
#> yaml 2.3.12 2025-12-10 [1] RSPM
#> zoo 1.9-1 2026-09-25 [1] RSPM (R 4.6.0)
#>
#> [1] /usr/local/lib/R/site-library
#> [2] /usr/local/lib/R/library
#> * ── Packages attached to the search path.
#>
#> ──────────────────────────────────────────────────────────────────────────────
Activity