Open vhpietil opened 6 years ago
Hi, I read data from SAS-table (.sas7bdat) using haven::read_sas and try to write the table to monetDBlite -database.
haven::read_sas
I get the error
Error in .local(conn, name, value, ...) : Failed to insert data: MALException:embedded:Could not convert column 0 start_time to type 15
Below is an example with a sample of the start_time-column (printed using dput):
dput
library(MonetDBLite) library(DBI) library(dplyr) dbdir <- tempdir() data <- structure(list(start_time = structure(c(43200, 44100, 45000, 45900, 46800, 47700), class = c("hms", "difftime"), units = "secs")), row.names = c(NA, -6L), class = c("tbl_df", "tbl", "data.frame"), .Names = "start_time") con <- dbConnect(MonetDBLite::MonetDBLite(), dbdir) dbWriteTable(con, "datatable", data)
R version 3.4.1 (2017-06-30) Platform: x86_64-redhat-linux-gnu (64-bit) Running under: Red Hat Enterprise Linux Server release 6.6 (Santiago) Matrix products: default BLAS: /usr/lib64/R/lib/libRblas.so LAPACK: /usr/lib64/R/lib/libRlapack.so locale: [1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C LC_TIME=en_US.UTF-8 LC_COLLATE=en_US.UTF-8 LC_MONETARY=en_US.UTF-8 LC_MESSAGES=en_US.UTF-8 [7] LC_PAPER=en_US.UTF-8 LC_NAME=C LC_ADDRESS=C LC_TELEPHONE=C LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] DBI_0.7 dplyr_0.7.4 MonetDBLite_0.5.1 loaded via a namespace (and not attached): [1] Rcpp_0.12.14 codetools_0.2-15 digest_0.6.15 assertthat_0.2.0 R6_2.2.2 magrittr_1.5 rlang_0.2.0 bindrcpp_0.2 tools_3.4.1 [10] glue_1.2.0 yaml_2.1.14 compiler_3.4.1 pkgconfig_2.0.1 bindr_0.1 tibble_1.3.4
Problem:
Hi, I read data from SAS-table (.sas7bdat) using
haven::read_sas
and try to write the table to monetDBlite -database.I get the error
Below is an example with a sample of the start_time-column (printed using
dput
):Example:
Sessioninfo: