Stack Overflow
Stack Overflow

Questions tagged [monetdb]

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.

441 questions
0
votes
2 answers

Spawn subprocess in R

I'm trying to spawn a sub-process in R using the subprocess library, as presented in this tutorial. The Problem is that the program I'm trying to launch requires an additional command after the executable. Example: I would launch the command from…
Claudio Brasser
  • 511
  • 3
  • 20
0
votes
1 answer

monetdb full outer join resulting in varchar type_digits=0

I am using MonetDB v11.29.7 "Mar2018-SP1" on a Windows10 x64 bit operating system. When I perform a full outer join with two tables on respective varchar columns with lengths > 0 (type_digits > 0), the resultant column in the target table yields a…
Peter Millington
  • 1
  • 1
0
votes
0 answers

MonetDb performance on a large table with 20K columns

I'm testing MonetDB as a solution for a data-science project. I have a table of 21K columns - all but three are features described as float (32bit) and 6.5M rows (which may or may not become larger, perhaps up to 20M rows). My aim is to use the…
malrsrch
  • 1
0
votes
1 answer

What is best tool to benchmark MonetDB

I'm currently searching for a MonetDB benchmark software. However, I'm a novice in this field and I can't find compatible benchmark tool for MonetDB. It seems like developers of MonetDB used "Xmark". However, it only supports MonetDB4 not MonetDB5.…
ghwns9652
  • 1
  • 1
0
votes
1 answer

Why is my DBI connector doing a dummy query with predicate "where 0 = 1"?

I have some R test code that I use to connect to a MonetDB instance. I notice that for each connection that I create through tbl(conn, "some_table") I somehow always end up with a 'primer' query of the form SELECT * FROM "some_table" AS…
Yunus King
  • 1,141
  • 1
  • 11
  • 23
0
votes
3 answers

Using tbl and src_monetdblite to access data

Sorry if this question has been asked elsewhere, I can't find it. I'm working through some basic examples in MonetDBLite. > dbGetQuery(dbcon, "SELECT MAX(mpg) FROM mtcars WHERE cyl = 8") L3 1 19.2 works, but > ms <-…
nzgwynn
  • 81
  • 1
  • 10
0
votes
1 answer

Installing MonetDB ODBC on windows 10 x64

The installation page does not mention Windows 10. Is it possible to download MonetDB ODBC for that OS? If so, where can I find the steps to do so. Thanks for your support.
nzgwynn
  • 81
  • 1
  • 10
0
votes
2 answers

MonetDB recursive CTE (common table expressions)

It seems MonetDB does not support recursive CTE. This is a useful feature that I used to get BOM from ERP systems. For a greater flexibility I used Firebird recursive stored procedures to enhance the output with extra calculations. A good example…
DanZ
  • 15
  • 6
0
votes
3 answers

Updating column based on other two tables

I have the following three tables as follows, select * from student_grade; +--------------+----------+----------+-------+--------------------------+ | enrollmentid | courseid | personid | grade | credits_earned …
Anil
  • 1,748
  • 8
  • 32
  • 67
0
votes
2 answers

Combine the output of different queries as a single query output

How do I combine the output of different queries. I have the following sql queries with the output: 1) select d.departmentid, d.name, count(distinct(sg.personid)) as noOfStudents from department d inner join course c on c.departmentid =…
Anil
  • 1,748
  • 8
  • 32
  • 67
0
votes
2 answers

sql inner join on more than 2 tables and aggregate function

I have the following tables, select * from department; +--------------+--------------+--------+------------+---------------+ | departmentid | name | budget | startdate | administrator…
Anil
  • 1,748
  • 8
  • 32
  • 67
0
votes
1 answer

MonetDB client compilation

I'm a beginner in the Database community. I have been trying to interface with MonetDB using C/C++ MAPI. I have installed MonetDB on my Ubuntu 14.04 LTS machine and when I try to compile a sample program from here, I get the following error: $ gcc…
Denzil
  • 326
  • 3
  • 15
0
votes
1 answer

monetdb cluster management can't setup

I'm trying to follow MonetDB docs on Cluster Management to setup a 3 nodes cluster using 3 Centos machines, I created the 3 dbfarm using monetdbd create /path/to/mydbfarm and from the first node, I run monetdb discover and it returns nothing where…
Elias Ghali
  • 823
  • 1
  • 13
  • 29
0
votes
0 answers

MonetDB insert wrong data

please help One of tables in database starts inserting wrong data. I'm doing simple insert into operator_poll(operator_id, poll_id, activity_id) values (1,2,3); and got +-------------+---------+----------------------------+-------------+ |…
redexp
  • 4,765
  • 7
  • 25
  • 37
0
votes
1 answer

Allow arbitrary user to read MonetDB's sys.queue

I created a user foouser and a schema fooschema with some tables in it. Foouser executes long-running queries to its tables in fooschema. Now I'd like to check on the status of the queries. However, foouser does not have sufficient permissions to…
dasup
  • 3,815
  • 1
  • 16
  • 25
1 2 3
…
29 30