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
11
votes
1 answer

Mutate variables in database tables directly using dplyr

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 = mtcars) data_mt <-…
Geet
  • 2,515
  • 2
  • 19
  • 42
7
votes
0 answers

Accessing MonetDBLite outside R

I created a big database using MonetDBLite in R and now I want to access the database outside R (e.g., with a general database GUI). Is there a way to do this? I do not want to replicate the data as I still want to access it through R. I do not…
flippke
  • 91
  • 2
5
votes
2 answers

Add new column to MonetDBLite table

I am trying to use R + MonetDB as a large-data analysis stack and am having trouble creating a new column and populating it with data from my analysis. Here is a toy example: library(MonetDBLite) library(DBI) data(mtcars) db <-…
Zelazny7
  • 39,946
  • 18
  • 70
  • 84
4
votes
0 answers

dplyr/dbplyr: sql table vs df speed

I am currently writing a function with dplyr to do calculations. The function turns out to be really slow when I input a tbl_sql object, but reasonably fast when I input a data.frame. An example, df = data.frame( a = rnorm(1000000), b =…
user9672798
  • 113
  • 1
  • 4
3
votes
1 answer

how to join tables on cases where none of function(a) in b

Say in MonetDB (specifically, the embedded version from the "MonetDBLite" R package) I have a table "events" containing entity ID codes and event start and end dates, of the format: | id | start_date | end_date | | 1 | 2010-01-01 | 2010-03-30…
anon
  • 33
  • 4
2
votes
0 answers

Inserts to MonetDB are not persistent

I'm importing point cloud data into MonetDB using MonetDBLite and Python. Since some processing steps are pretty CPU-intensive, I'm parallelizing the processing to operate on two cores. At the end of the preprocessing, the data is loaded into…
sedot
  • 577
  • 5
  • 16
2
votes
1 answer

Cannot install Monet DB Lite for R Ubuntu 17.10

I try running: install.packages("MonetDBLite") in R. However, I get the following error: cc1: error: -Wformat-security ignored without -Wformat [-Werror=format-security] cc1: some warnings being treated as errors Makevars:194: recipe for…
drizzle123
  • 517
  • 5
  • 18
2
votes
0 answers

Problems with user-defined aggregate functions

I'm having some trouble when defining aggregate functions. Here’s a reproducible example: library(MonetDBLite) library(dplyr) library(DBI) dbdir <- tempdir() con <- dbConnect(MonetDBLite()) dbWriteTable(con, "mtcars", mtcars, overwrite = TRUE) ms…
user6948837
2
votes
0 answers

MonetDBLite - problems installing package

I've been trying to run this script: https://github.com/ajdamico/asdfree/blob/master/Pesquisa%20Nacional%20por%20Amostra%20de%20Domicilios/download%20all%20microdata.R But on this line install.packages( c( "MonetDBLite" , "survey" , "SAScii" ,…
Roberto Dumke
  • 21
  • 1
2
votes
1 answer

Error: 'MonetDBLite' is not an exported object from 'namespace:MonetDBLite'

Working through a download script for CPS data found here. Using the script verbatim, per recent update, except for the Java modification that I added for my environment (below) to fix a previous error in loadnamespace. While I am familiar with the…
Jebediah15
  • 754
  • 3
  • 18
  • 39
2
votes
1 answer

MonetDBLite without R in a C++/Qt application

Is there a way to use MonetDBLite as a storage engine in a C++ application without installing the R package? Or are there any other ways of using MonetDB as an embedded database like SQLite?
olafpadme
  • 76
  • 7
2
votes
1 answer

One big table or many smaller tables

I've read through MonetDB.R/MonetDBLite posts on this site, the CRAN PDFs, as well as some of the documentation on the MonetDB site and confess to being at the bottom of what appears to be a steep learning curve. The MonetDBLite documentation lists…
Val Dalin
  • 57
  • 6
2
votes
1 answer

Using custom function in mutate() with dplyr & monetDB

I am just beginning to discover all the advantages of using R & monetDB/monetDBLite package - great stuff! I was curious however if it's possible to use a custom defined function in dplyr's mutate() i.e. # Connect to monetDBLite db <-…
davidski
  • 561
  • 1
  • 4
  • 16
2
votes
2 answers

R package calls for library update

So I'm trying to implement some R script that you can see here. I'm using R 3.2.3 on Mac OS 10.10.5. But an error is stopping me, and it involves a part of the library I'm not familiar with. The problem comes up when I try and load MonetDBLite with…
J. Trimarco
  • 149
  • 1
  • 8
2
votes
1 answer

Unable to Bulk Import Free flow text MonetDB.R

I am trying to import a dataset of 217,000 records (Jeopardy Dataset) into MonetDB through the MonetDB.R interface. The file is a CSV file with top two lines as folows: show_nos, air_dt, rnd, category, prize, ques,…
Jjs
  • 21
  • 2
1
2 3 4