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
4 answers
Cannot create a database on a fresh installed monetdb
I'm new using MonetDB. I've follow this installation guide http://www.monetdb.org/Documentation/Guide/Installation
and I'm facing a problem to just create a database. Here is the error
monetdb create /tmp/c
monetdb: cannot find a control socket, use…
Fopa Léon Constantin
- 11,863
- 8
- 48
- 82
2
votes
1 answer
Unable to connect R to MonetDB (MonetDB.R)
I'm trying to start with the MonetDB.R package but I struggle to setup a connection (dbConnect).
Here is a reproductible example
require(MonetDB.R)
drv <- dbDriver('MonetDB.R')
con <- dbConnect(drv, 'monetdb://localhost/demo')
## Process R aborted…
dickoa
- 18,217
- 3
- 36
- 50
2
votes
1 answer
How to subset monet.frame with %in% properly
It seems everything is ok if
subset(mdf, id %in% c("A","B"))
but error if
ids = c("A","B")
subset(mdf,id %in% ids)
The following is demo codes:
con1 = dbConnect(dbDriver("MonetDB"),"monetdb://go:50000/voc")
d =…
wind
- 313
- 4
- 7
2
votes
2 answers
Have the monetdb's developers tested any other compression algorithm on it?
Have the MonetDb's developers tested any other compression algorithm on it before?
Perhaps they have tested other compression algorithms ,but it's really had a negative performance impact.
So why haven't they improved this database's compression…
user2994562
- 31
- 2
2
votes
1 answer
Node.js and ODBC for MonetDB
I am trying to use odbc to connect to monetDB in node.js. However, I keep getting the following error:
The driver reported the following diagnostics whilst running SQLDriverConnect
IM002:1:0:[unixODBC][Driver Manager]Data source name not found, and…
user396404
- 2,759
- 7
- 31
- 42
2
votes
1 answer
How could we know that monetDB is using Index?
I have loaded 150 million records into MonetDB. All data inserted into a single table. The table does not have any constraint(ex. UNIQUE, ..). I have not created any index myself. The original source CSV file is about 7.2 GB and after importing…
Majid Azimi
- 5,575
- 13
- 64
- 113
1
vote
1 answer
After stopping MonetDB, mserver still appear to be running, and restart is now impossible. Does anyone know why?
I'm new to using MonetDB for my data. My dataset is currently about 1TB in size (spread across lots of tables).
About an hour or two ago, I ran monetdbd stop db and monetdb stop db (both the dbfarm and the database are named "db").
I would have…
Seán Healy
- 61
- 6
1
vote
1 answer
Bulk upload using csv file to remote MonetDB server
I have a remote MonetDB server running and I want to bulk upload a csv file as it is much faster.
Based on the params in MonetDB.R, there is a csvdump=TRUE option but I don't think it works when you are trying to do this against a remote server. The…
t_creasman
- 43
- 3
1
vote
0 answers
Time Series Downsampling/Upsampling
I am trying to downsample and upsample time series data on MonetDB.
Time series database systems (TSDS) usually have an option to make the downsampling and upsampling with an operator like SAMPLE BY (1h).
My time series data looks like the…
AbdelKh
- 499
- 7
- 19
1
vote
1 answer
Weka and SQL Server 2019 (Mac OS Big Sur 11.5 beta, MacBook Pro M1) connection problems
Good evening. I hope someone can help me with this one...
I made sure I installed weka 2-8-5 azul zulu for mac, Intel, since the ARM dmg installer seems to be corrupted. I get a damaged package message, using OS big sur 11.5 beta and MacBookPro…
Michael Prendergast
- 11
- 3
1
vote
1 answer
Cannot execute tests using Mtest.py in MonetDB
I am currently trying to get going with developing additional functionality for the MonetDB DBMS. I have been reading through the code and tried to debug the code using VSCODE which actually works fine. However, I encountered difficulties when…
mledl
- 13
- 5
1
vote
1 answer
How to express "either the single resulting record or NULL", without an inner-query LIMIT?
Consider the following query:
SELECT (SELECT MIN(col1) FROM table1) = 7;
Assuming col1 is non-NULLable, this will yield either true or false - or possibly NULL when table1 is empty;
But now suppose I have:
SELECT (
SELECT
FIRST_VALUE (col2)…
einpoklum
- 118,144
- 57
- 340
- 684
1
vote
1 answer
Latest MonetDB in Docker container
I'm facing a new personal BI project, and my idea is based on Pentaho. I'm very interested in MonetDB as database, and I'd like to use it as a Docker container.
I came across the official MonetDB Docker Hub repository…
Llorieb
- 25
- 5
1
vote
2 answers
are COPY commands possible with MonetDBe-Python?
I was having some trouble bulk-loading records to go faster than what cursor.executemany would allow. I hoped the bulk operations documented with regular MonetDB here might work, so I tried an export as a test. e.g. cursor.execute("COPY SELECT *…
dcc310
- 1,038
- 1
- 9
- 13
1
vote
2 answers
SQL : Concatenate data from a column depending on another column and reading row above
I am writing you because I can't find any solution to my problem, and I don't even know if there is a way to do it. I'm working in SQL (MonetDB).
I have a table like this…
Sp21nk
- 45
- 3