Stack Overflow
Stack Overflow

Questions tagged [monetdb]

MonetDB is an open-source implementation of a column-oriented database. It is focused on analytical applications on a main memory resident database. MonetDB is a relational database and provides an SQL top-level interface. It is actively developed at CWI in Amsterdam, The Netherlands.

441 questions
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

MonetDB storage() function

From MonetDB docs https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/storage-model, The storage footprint for any given database schema can be obtained by inspecting the table producing function storage() Here's a sample query from the…
Sahas
  • 10,637
  • 9
  • 41
  • 51
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
0 answers

Creating an embedded R windowing function in monetdb

I'm trying to create a windowing aggregate function using embedded R in monetdb. The function I have used is: CREATE AGGREGATE r_sw(val double, part varchar(255), endtime timestamp, starttime timestamp) RETURNS double LANGUAGE R…
TimBrown
  • 173
  • 6
2
votes
1 answer

MonetDB -R connector installation

I have started using MonetDB and R.I am trying to install it's connector.But unfortunately the machine where I have installed these two doesn’t have internet accessibility so the mirrors are not accessible. can someone tell me some other way to…
Debangana
  • 87
  • 3
2
votes
1 answer

Does MonetDB support tables > 70k columns

Does MonetDB support tables with ~74,000 columns? Number of Columns: 74,000 columns. Yes I am asking about a table with seventy-four-thousand columns. Data types: All data types for columns in these tables would be a mix of 50% of columns Int,…
Webby
  • 337
  • 1
  • 3
  • 10
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
2
votes
1 answer

How are null values stored in MonetDB

I have a column of 4 byte integers that contains a lot of Nulls. I would like to know how are null values represented in storage. Do they use up 4 bytes as well or they are handled in a way they don't waste space?
marcin_koss
  • 5,763
  • 10
  • 46
  • 65
2
votes
1 answer

Unable to combine large survey dataframes in R using MonetDB and MonetDBLite

I am trying to concatenate or rbind 12 years of survey data, each with several million observations and a hundred or so variables so as to analyze annual trends while accounting for the survey structure. The recent release of MonetDBLite for R…
charlie
  • 602
  • 4
  • 12
2
votes
1 answer

Quoting in MonetDB

I have some PHP code that I'm trying to port from MySQL to MonetDB. The code uses ODBC, so in theory it should just be a case of changing the driver. Here's an example of the SQL being generated by PHP and sent to the database: SELECT mycolumn FROM…
AndyT
  • 99
  • 7
2
votes
1 answer

dbListConnections & MonetDB - which user is connected?

I am using MonetDB with R thanks to the library MonetDB.R. I do not seem to be able to use dbListConnections I get: > dbListConnections(dbDriver("MonetDB.R")) Error in (function (classes, fdef, mtable) : unable to find an inherited method for…
Enzo
  • 2,543
  • 1
  • 25
  • 38
2
votes
2 answers

monetdb: switch off password on mclient

I'd like to access monetdb database without password verification. I need this to put code into bash script and automatize some queries. Command mclient -u monetdb -d database asks for password, which I'd like to omit (by default password is…
golazo
  • 221
  • 1
  • 11
2
votes
1 answer

How to create a year column in monetdb to automatically be set with the current time

I want to create a table with default value set to the current year CREATE TABLE Date ( "year" smallint NOT NULL DEFAULT extract(year from current_time) ); It throws an error: !42000!syntax error, unexpected YEAR in: "select year" The same…
Brenda Olivia Martis
  • 563
  • 2
  • 6
  • 18
2
votes
0 answers

How to improve performance with MonetDB on OSX?

I am using monetdb on a 16GB Macbook Pro with OSX 10.10.4 Yosemite. I execute queries with SQLWorkbenchJ (configured with a minimum of 2048M RAM). I find the performance overall erratic: performance is acceptable / good with small size tables…
Enzo
  • 2,543
  • 1
  • 25
  • 38
2
votes
2 answers

migrating from Postgres to MonetDB

I need to know how to migrate from Postgres to MonetDB. Postgres is getting slow and we are trying to change to Monet. Someone now if already exists a script or another thing to migrate to Monet? exist something equivalent to plpgsql on…
João Manoel
  • 23
  • 3
1 2 3
…
29 30