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
1 answer
MonetDB install with Java 1.8 Error - Unsupported major.minor version 52.0
I am following the MonetDB install procedure described by Hannes Mühleisen by running commands 1 to 6 described below.
how do I install MonetDB on Centos 6.5?
sudo yum install openssl-devel pcre-devel
tar xvf MonetDB-.tar.
cd…
user2238704
- 121
- 8
0
votes
1 answer
How to tell MonetDB that data are sorted in the table?
Given a table data (as described below) and given the insurance that that values imported into this table are sorted.
CREATE TABLE data (INT value)
CREATE INDEX index_value ON data (value)
Since MonetDB can neglect the CREATE INDEX statement (see…
Fopa Léon Constantin
- 11,863
- 8
- 48
- 82
0
votes
1 answer
Cleaning up after MonetDB heap memory allocation error
I executed improper sql statement that syntactically correct but caused MonetDB to fail at allocating heap memory trying to allocate 490G. In result disk ran out of space and seems MonetDB never cleaned up. One of the subdirs in /bat holds 127G…
marcin_koss
- 5,763
- 10
- 46
- 65
0
votes
1 answer
MonetDB - issue with dumping results of select statement into file
I'm using "COPY SELECT ... INTO file" statement from within application code. After file is ready, next step is to move the file to different location. The only problem is that file created by MonetDB has only root permissions so my application code…
marcin_koss
- 5,763
- 10
- 46
- 65
0
votes
1 answer
setting up remote connection with an existing monetdb db
I create a monetdb database using mserver5 (in actual fact I use R and MonetDB.R for this part).
Retrospectively (once the db has been created) I would like to do the following:
set a remote connection to the db
set a passphrase for the remote…
Enzo
- 2,543
- 1
- 25
- 38
0
votes
1 answer
How to show available tables in monetdb using python api?
When using mclient it is possible to list all tables in database by issuing command '\d'. I'm using python-monetdb package and I don't know how the same can be accomplished. I've seen example like "SELECT * FROM TABLES;" but I get an error that…
marcin_koss
- 5,763
- 10
- 46
- 65
0
votes
3 answers
Looking for a database solution for mostly read application, querying 300 million records
Looking for right database technology to query efficiently 300 mil record tables. Tables may contain 5-30 columns mostly tinyint + zip, state. Users can issue arbitrary queries with where conditions on many columns and group with count either by…
marcin_koss
- 5,763
- 10
- 46
- 65
0
votes
2 answers
Make Connection to MonetDB using .Net
has anyone work wit monetDb and .Net. I am having a hard time to find the right Connection String for the MonetDB using .Net.
So far I know this from documentation and some other forums.
My monetserver is running on one machine and the .Net client I…
Anup Shah
- 1,256
- 10
- 15
0
votes
1 answer
MonetDB - Insert data to one column
I have a table with 5 columns:
CREATE TABLE "voc"."MyTable" (
"c_1" TINYINT,
"c_2" TINYINT,
"c_3" TINYINT,
"c_4" TINYINT,
"c_5" TINYINT
);
I want to calculate the values for each column in separate, and…
yishaiz
- 2,433
- 4
- 28
- 49
0
votes
1 answer
Which open source dashboard/BI tools can work with monetDB?
I'm trying to create a rich online dashboard to analyze web traffic with monetDB.
Does anybody know how to integrate with an open source solution ?
GBrian
- 1,031
- 11
- 28
0
votes
1 answer
Create field called "Year" in MonetDB
How do I create a field with a reserved word as the name in MonetDB?
In MySQL I would just surround the field name with backticks, but this doesn't work in MonetDB. What gives?
Darth Egregious
- 18,184
- 3
- 32
- 54
0
votes
1 answer
generate 100 milions record with monetdb
my assignment is make a database with 100 millions record in mongetdb.for now my solution is generate a big file db.sql then import . size of that file is bigger than 6gb. I have imported near to 2 days.and i don't know when it finish. Somebody help…
Phantanx
- 15
- 6
0
votes
1 answer
How can I get the current value of a sequence in MonedDB?
For example, in PostgreSQL I can write the following lines to increment the sequence and to get the current value:
SELECT nextval('sequence');
SELECT currval('sequence');
In MonetDB I know how to write the first line:
SELECT NEXT VALUE FOR…
Daniel Hernández
- 1,279
- 8
- 15
0
votes
2 answers
How do I check whether i have configured monetdb to use BWD?
I am working on monetdb and trying to run bitwise decomposition in it.
I am able to rum the server and the client window, but how do I check whether the BWD is implemented in it?
I also need to check how many CPUs anf GPUs my monetdb uses. How can…
Hari
- 67
- 2
- 9
0
votes
1 answer
Does Monetdb support server-side scripting like PG/SQL?
Hi I read Here that MonetDB support server-side script (like PG/SQL for Oracle). However I'm not able to found any related documentation on the MonetDB website
Can some one have any pointers, documentation, tutorial about server-side scripting in…
Fopa Léon Constantin
- 11,863
- 8
- 48
- 82