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
4
votes
1 answer
How to discover the columns for a given index or key in MonetDB
MonetDB seems to support a fairly comprehensive set of system catalog views in order to discover the schema structure of the database. Unfortunately, I can't seem to find a SQL query that will obtain the set of columns for a given key or index. …
N8allan
- 2,138
- 19
- 32
3
votes
2 answers
how to create a BAT file to be used in monetdb bulk load from a Java program
I have a file with a list of string (one cloumn).
File example
sdfsdfsdf
hfhfhfghf
dfgdggdfg
pookokkoo
base on the documentation on monetdb web site, I have to create a BAT file.
How do I convert my file with strings into a BAT file ready to be…
Federico
- 5,438
- 5
- 39
- 47
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
3
votes
2 answers
How to improve query performance on a single node in MonetDB?
I've installed the latest (MonetDB 5 server v11v.27.5 "Jul2017-SP1") on Windows 2012 Server and I'm trying to query large table 1,4 billion rows in a reasonable time 2-3s.
Is this even possible with MonetDB? What could I do to improve the…
Tomáš Repík
- 145
- 2
- 10
3
votes
4 answers
Database recommendation
I have a collection of data that looks as follows:
id name c1 c2 c3 c4 ... c50
-----------------------------------------------
1 string1 0.1 0.32 0.54 -1.2 ... 2.3
2 string2 0.12 0.12 -0.34 2.45 ... …
Brett
- 11,637
- 34
- 127
- 213
3
votes
2 answers
How to execute a query string in MonetDB
I'm attempting to declare a query string to execute in MonetDB. The documentation is not clear if this is possible, but other engines allow this functionality (such as MySQL and MS SQL Sever). Trying the following
execute 'select * from…
영민 카이 앤절
- 155
- 7
3
votes
2 answers
How can I EXPLAIN several consecutive queries without executing them?
Suppose I have a pair of arbitrary SQL queries, each one depending upon the former ones, e.g.
CREATE VIEW v1 ( c3 ) AS SELECT c1 + c2 FROM t1;
SELECT sum(c3) FROM v1;
DROP VIEW v1;
(but note I am not asking about these specific queries - this is…
einpoklum
- 118,144
- 57
- 340
- 684
3
votes
2 answers
MonetDB bulk load with auto increment
I am trying to load csv files into monetdb table(s) with auto increment PK/Id columns using copy into from file....
table has auto increment PK column.
table has more columns than incoming csv files.
csv file doesnt have Pk/Id column.
Is…
