Stack Overflow
Stack Overflow

Questions tagged [monetdblite]

MonetDBLite is an embedded version of MonetDB, a relational database with a SQL interface. MonetDB uses a columnar storage model and is most suited for analytical workloads. Currently, MonetDBLite is available for R.

MonetDBLite is an embedded version of MonetDB, a relational database with a SQL interface. MonetDB uses a columnar storage model and is most suited for analytical workloads. Currently, MonetDBLite is available for R. Details: https://www.monetdb.org/blog/monetdblite-r

46 questions
0
votes
1 answer

Problem using WHERE clause in MonetDBLite in R

I am trying to use MonetDBLite in R64bit 3.5.1. My problem is that I can not filter the data using SQL command like this example: dbGetQuery(DB,'select * from table1 where "var1" = "1"') I get this error: Error in .local(conn, statement, ...) : …
Alirezaaa
  • 45
  • 4
0
votes
1 answer

update aTable set a,b,c = func(x,y,z,…)

I need a quick advice how-to. I mention that the following scenario is based on the use of c_api available already to my monetdblite compilation on 64bit, intention is to use it with some adhoc C written functions. Short: how can I achieve or…
DanZ
  • 15
  • 6
0
votes
3 answers

Using tbl and src_monetdblite to access data

Sorry if this question has been asked elsewhere, I can't find it. I'm working through some basic examples in MonetDBLite. > dbGetQuery(dbcon, "SELECT MAX(mpg) FROM mtcars WHERE cyl = 8") L3 1 19.2 works, but > ms <-…
nzgwynn
  • 81
  • 1
  • 10
0
votes
1 answer

Installing MonetDB ODBC on windows 10 x64

The installation page does not mention Windows 10. Is it possible to download MonetDB ODBC for that OS? If so, where can I find the steps to do so. Thanks for your support.
nzgwynn
  • 81
  • 1
  • 10
0
votes
1 answer

Connecting to an existing db farm using MonetDBLite C API

I have a DB farm created with a database (ex: temp). When I try to connect to that using monetdb_startup, get the following error. src/gdk/gdk_utils.c:1465: GDKfree: Assertion `(asize & 2) == 0' failed. Aborted (core dumped) I'm using the…
kiran
  • 3
  • 3
0
votes
1 answer

Using monetdb_append from MonetdbLite C API

I am trying to use MonetDBLite C in an application. According to the PDF (https://arxiv.org/pdf/1805.08520.pdf), I would benefit from a boost in speed in loading massive amount of data using monetdb_append function. From PDF: In addition to issuing…
DanZ
  • 15
  • 6
0
votes
1 answer

Add a variable to a table in MonetDBLite

Here is mtcars data in the MonetDBLite database file. library(MonetDBLite) library(tidyverse) library(DBI) dbdir <- getwd() con <- dbConnect(MonetDBLite::MonetDBLite(), dbdir) dbWriteTable(conn = con, name = "mtcars_1", value =…
Geet
  • 2,515
  • 2
  • 19
  • 42
0
votes
0 answers

type 5 error while using MonetDBLite or readr

I am trying to write 80GB csv file onto the MonetDB using MonetDBLite using the following code. mtcars[1:12,] %>% write_csv("mtcars1_12.csv") mtcars[13:32,] %>% write_csv("mtcars13_32.csv") setwd("path") # please use your folder path dbdir <-…
Geet
  • 2,515
  • 2
  • 19
  • 42
0
votes
1 answer

Correct camelCase Column Name

I forget to change a column name from camel case to underscore style before creating the embedded db. Typically, I would use ALTER TABLE table_name RENAME "camelCase" TO underscore_style; to rename the offending column. However, that syntax errors…
EunosNB
  • 41
  • 6
0
votes
2 answers

Dplyr speed when connected to Monetdblite/RSQLite database on external hard drive?

A beginner's question. I'm using R with dplyr to analyse large amounts of data but I don't have access to a server-based database. In addition, my computer's internal hard drive is too small for the databases that I need to create. I have been using…
Maarölli
  • 375
  • 1
  • 3
  • 13
0
votes
0 answers

Does MonetDBLite support auto-commit mode?

I am trying to optimize data upload in an R package using MonetDBLite. As per the MonetDB website, using LOCKED mode can speed up upload: LOCKED mode In many bulk loading situations, the original file can be saved as a backup or recreated for…
lmrta
  • 305
  • 1
  • 2
  • 13
0
votes
1 answer

Incompatible server error R MonetDBLite()

I have a large MonetDB database I created last year using R DBI::dbWriteTable. When I try to establish a connection with dbConnect(MonetDBLite(), "~/myfile") returns the error: Error in monetdb_embedded_startup(embedded,…
charlie
  • 602
  • 4
  • 12
0
votes
0 answers

MonetDBLite dir does get smaller after table drop

Every time I drop a table and import new data in a newly create table, the footprint of MonetDBLite keeps getting larger. Is there anything like a sweep I need to do to reclaim the space every time a table is dropped? Here is the snippet I use to…
Fred R.
  • 557
  • 3
  • 7
  • 16
0
votes
1 answer

MonetDB - COPY INTO bulk insert with special char \

I'm using COPY INTO to bulk insert some data into MonetDB. The csv that I'm copying from has some special characters like \ in some string fields and it broke the insertion. The error that I got is: Failed to import table line 1 field 11 'clob'…
Saed Hammad
  • 96
  • 10
0
votes
1 answer

hHw to pass a system function to MonetDB through R?

Using MonetDB.R, I want to run this command but I don't want to open up mclient. Is there a generic way to do this? create function div_noerror(l double, r double) returns double
Anthony Damico
  • 5,779
  • 7
  • 46
  • 77
1 2
3
4