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
0
votes
0 answers
R + MonetDB - group by memory footprint
I'm about to start using MonetDB soon, but it's a high fixed cost for switching over from MySQL. The main appeal is compiled in-database R.
Question is: How does MonetDB's memory footprint evolve with WHERE and GROUP BY
Consider the following…
grad student
- 107
- 7
0
votes
1 answer
Add custom jar grails 2.4.3
I'm adding a downloaded jar to my lib folder, but when I try to use it doesn't work.
Here is the code:
// make sure the ClassLoader has the MonetDB JDBC driver loaded
Class cls = Class.forName("nl.cwi.monetdb.jdbc.MonetDriver");
// request a…
Federico
- 58
- 2
- 12
0
votes
1 answer
How to manage schemas in R & MonetDB?
I've asked a similar question recently, more geared toward dplyr.
See dplyr & monetdb - appropriate syntax for querying schema.table?
As dplyr & MonetDB (according to @Hannes Mühleisen reply above) don't have a proper way to manage schemas, I…
Enzo
- 2,543
- 1
- 25
- 38
0
votes
1 answer
MonetDB multi thread support
I use MonetDB in my .net project via odbc driver.
Does monetDB support multi thread insert, update, delete via odbc?
When I tried to test it I have got ODBCException: general exception.
How does MonetDB handles concurrent requests?
Thanks!
D. Tikhonov
- 13
- 4
0
votes
1 answer
Getting started with Datacell on MonetDB
I am a master student working with MonetDB for my thesis. I installed MonetDB and now I need to work with the DataCell extension to proceed. I am on Lubuntu 15.04 and started the MonetDB tutorial, however when I begin to work with the DataCell…
p.debugging
- 41
- 1
0
votes
2 answers
Grails and python integration
I have a Monet database to which I need to make a query remotely. There's a plugin for python which would make easier to make the query, but I'm creating a grails application.
So I need to create a Python module to make the query, and somehow…
diebarral
- 61
- 12
0
votes
1 answer
MonetDB stored procedure return table
From MonetDB-user's:
You cannot use an ordinary select query in a procedure. You can change
the contents of tables or set variables, but you cannot use a query like
this. Remember, with such a query, there is a result, and where should
the…
GBrian
- 1,031
- 11
- 28
0
votes
1 answer
Connecting to MonetDB using ODBC
I have tried using unixODBC (version 2.3.2) and the MonetDB ODBC client (version 11.21.5) on both Mac OS X 10.9 and Debian 8, but cannot connect through ODBC using isql on client machines to a MonetDB server running on Debian 8, although it works…
Endre
- 690
- 8
- 15
0
votes
1 answer
Connect to MonetDb Virtualbox from node.js server app
I am trying to connect Monetdb database, and I would like to use it with a node.js server app.
I currently set up a VirtualBox environment with monetdb package, as described here, and it works well:…
bobby
- 674
- 3
- 10
- 14
0
votes
2 answers
How MonetDB uses indexes?
I know MonetDB is a self indexing databases but how does this actually work?. I would like to learn more about how this works internally. Does MonetDB create compound indexes as well or is it just per column? What indexing strategy is being used? I…
marcin_koss
- 5,763
- 10
- 46
- 65
0
votes
1 answer
connection pooling with MonetDB, R and Shiny Pro
With R and Shiny Pro it is possible to implement multi-user analytical applications.
When a database is used to store intermediate data, how to give access to multiple user access to the db becomes very relevant and necessary.
Currently I'm using…
Enzo
- 2,543
- 1
- 25
- 38
0
votes
1 answer
Union and limit in one query in MonetDB
How can I write following query in MonetDB:
CREATE TABLE "sampled" AS (
SELECT *
FROM "base"
WHERE "target" = 'B'
LIMIT 30
) UNION ALL (
SELECT *
FROM "base"
WHERE "target" = 'A'
LIMIT 30
) WITH DATA
?
When I attempt to execute the…
user824276
- 617
- 1
- 7
- 20
0
votes
1 answer
MonetDB parallel query high IO write activity
While testing Monetdb on Linux I can see a lot of IO write activity. The data set is 2GB (30 Million rows) and system has 120GB free RAM
The query:
select sum(hits) from (select "hour","minute","second", server, count(*) as hits from iislogs group…
GBrian
- 1,031
- 11
- 28
0
votes
0 answers
Monetdb Select Consuming To much Time
To everyone everyone we are using monetdb for storing considerably large amount of data, It works fine with complex queries but failed in performance to simple select statement when it comes to present data. HERE is a simple command RUN on table…
sharafjaffri
- 2,134
- 3
- 30
- 47
0
votes
0 answers
monetdb failed to bulk load 42000 syntax error
I'm trying to bulk load some data into monetdb.
I followed this example.
It works for my test data. But when I use the data from production environment, I get exceptions.
Caused by: java.lang.Exception: 42000!syntax error, unexpected IDENT,…
scarcer
- 213
- 5
- 16