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.
Questions tagged [monetdb]
441 questions
2
votes
1 answer
monetdb - Is concurrent query execution supported
Is concurrent query execution supported in monetdb?
While testing simultaneous query execution I found that only one query is getting executed at one time. Rest of the queries are put of hold until the first one gets completed. The test database has…
jcarlson
- 21
- 1
2
votes
1 answer
Monetdb - CPU Threads Utilization
I have recently installed monetdb "OCT 2014-SP1" release on my Oracle Enterprise 6 Linux server.
Server configuration -
8 CPU Cores
64 GB RAM
I have loaded a data set with 70 columns having 15 Millions Rows.
I have started mserver5 as below…
UberNeo
- 1,298
- 2
- 14
- 16
2
votes
1 answer
Creating additional dbfarm in MonetDb
I have created a dbfarm in MonetDb. then I've moved the directory of the dbfarm to another location, and the dbfarm stopped working. So I'm trying to fix that by deleting the old dbfarm and/or creating a new one
The problem is that when trying to…
yishaiz
- 2,433
- 4
- 28
- 49
2
votes
1 answer
Alter the data type of a column in MonetDB
How can I alter the type of a column in an existing table in MonetDB? According to the documentation the code should be something like
ALTER TABLE ALTER COLUMN SET ...
but then I am basically lost because I do not know…
okartal
- 2,806
- 1
- 15
- 11
2
votes
1 answer
String function in monetdb
Does Monetdb supports string function like concat_ws in Postgresql (http://www.postgresql.org/docs/9.1/static/functions-string.html) ?
Edit: Monetdb reference
I look in the Monetdb reference about supported operations, but nothing was related to…
Fopa Léon Constantin
- 11,863
- 8
- 48
- 82
2
votes
0 answers
Optimizing sql queries for deleting duplicates in Monetdb
I have a problem where I have a market data table with >100,000,000 rows and I need to search and remove duplicates where the symbol and totvol columns match but the serial_no is different.
I have tried the query below on both a single table and…
Gadesxion
- 391
- 2
- 6
- 18
2
votes
4 answers
MonetDB.R bulk insert
Is there a way to do a bulk insert using MonetDB.R (not via a for loop and dbSendUpdate)?
Does dbWriteTable allow for updates (append=TRUE)?
About "INSERT INTO" the MonetDB documentation states:
"The benefit is clear: this is very straightforward. …
Bart Lenoir
- 41
- 3
2
votes
1 answer
SQL: Auto insert current date as string/varchar
I would like to set up a schema which will store the current date as a string fitting in a varchar column of size 10. However CURDATE() returns as a date type, is there any way I can convert this when creating a table to automatically convert this…
Gadesxion
- 391
- 2
- 6
- 18
2
votes
1 answer
MonetDB; !FATAL: BBPextend: trying to extend BAT pool beyond the limit (16384000)
Our monetdbd instance throws the error "!FATAL: BBPextend: trying to extend BAT pool beyond the limit (16384000)" after restarting from a normal shutdown (monetdbd start farm works, monetdb start database fails with the given error).
The database…
Degola
- 21
- 2
2
votes
1 answer
In MonetDB, can I obtain the database name via SQL commands?
Does MonetDB make the current DB name (i.e. not the DBMS hostname, but the DB, or set of tables, that you connect to) available via SQL queries to some of the system table?
einpoklum
- 118,144
- 57
- 340
- 684
2
votes
1 answer
MonetDB Slow Query with Index
I created a table with 10GB (60M records), added unique index (hidden_id) manually after data insertion.
I had the simplest query but it took one minutes to complete.
select hidden_id from netflow where hidden_id = 350000;
And also the query took…
Summer
- 21
- 2
2
votes
1 answer
How to use connection pooling for Monetdb?
Can some tell me how to use connection pooling with MonetDb? Do I just append these args to the URL "poolminimum=1;poolmaximum=5;"?
user3328923
- 143
- 2
2
votes
1 answer
How to update a table using another table or aggregation results from subquery?
Firstly, I'm using MonetDB branch from MonetDB Database Server Toolkit v1.1 (Feb2013-SP1)
I have two tables, and want to complete the following two functions without creating a temporary table:
1) update one table from another table; and
2) update…
Ning
- 461
- 4
- 9
2
votes
2 answers
monetdb - copy into from...requires tables without indices
I get this error with Monetdb when I try to load .tbl data in tables where there are primary key and foreign key, what's wrong?
This is the command:
COPY INTO monet.CUSTOMER FROM '/home/nicola/Scrivania/ssb-dbgen-master/1gb/customer.tbl' USING…
Mark
- 141
- 1
- 3
- 15
2
votes
1 answer
Is MonetDB.R's `na.omit` broken?
I think there's a bug in how MonetDB.R filters NAs, see example code below:
Handy utility function for doing general SQL-queries on monet.frame objects:
#' Apply general SQL queries to a monet.frame object and return the
#' result in a new…
fabians
- 3,383
- 23
- 23