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
1 answer

Connecting to MonetDB server on guest virtual machine from host

I have a virtual machine (centos 7) in VirtualBox on a RHEL 5 host running MonetDB5 (server v 11.19.9). I can connect to the database from with the guest through both jdbc and mclient. However, I cannot connect to it from the host. I have port 50000…
njnnja
  • 43
  • 1
  • 4
0
votes
0 answers

Pentaho error: javac: invalid target release: 7

I'm trying to build pentaho with ant command, but I'm getting this following error compile.compile: [javac] Compiling 369 source files to /opt/pentaho-kettle/pentaho-kettle/core/bin/classes [javac] javac: invalid target release: 7 …
Brenda Olivia Martis
  • 563
  • 2
  • 6
  • 18
0
votes
1 answer

monetdb with web.py (raise UnknownDB, dbn issue)

I tried using web.py framework to the monetdb. This is my implementation code : import web render = web.template.render('templates/') db = web.database(dbn = 'monetdbd', user = 'monetdb', pw = 'monetdb', db = 'test') urls = ( …
Brenda Olivia Martis
  • 563
  • 2
  • 6
  • 18
0
votes
1 answer

MonetDB causing disk space to fill up

I have a bunch of test queries which I am testing against MonetDB. Queries all by itself run fine but if you run the same set of queries in a loop disk runs out of space. I am not sure why would memory map files won't clean up automatically and why…
user3517179
  • 31
  • 7
0
votes
1 answer

monetdb embedded R

I am trying to use the embedded R feature in Windows 7. I start the server with mserver5 --set embedded_r=true I do not see the message # MonetDB/R module loaded though. Then I wanted to test the example rapi00 provided here: CREATE FUNCTION…
teucer
  • 6,060
  • 2
  • 26
  • 36
0
votes
1 answer

Create function in MonetDB

I'm trying to add a simple function in to monetDB at database level, which just does sum(n) and returns the result create function sys.foo(number int) returns int begin declare tsum int; set tsum = 0; while number > 0 do set tsum = tsum +…
Aravind S Reddy
  • 1
  • 1
0
votes
1 answer

Removing MonetDB from Ubuntu 14.04 server and reinstalling it from source

I want to uninstall monetdb from ubuntu 14.04 server platform so that i can install it again from the source. Also i want my db farm not to be removed while uninstalling the monetdb. How to acchieve this ?
Manoj
  • 1
  • 3
0
votes
1 answer

hHw to pass a system function to MonetDB through R?

Using MonetDB.R, I want to run this command but I don't want to open up mclient. Is there a generic way to do this? create function div_noerror(l double, r double) returns double
Anthony Damico
  • 5,779
  • 7
  • 46
  • 77
0
votes
1 answer

Apache Spark fails to connect to MonetDB Cluster using JDBC Driver

We have problems connecting to a MonetDB Cluster via Apache Spark using JDBC. Connection to a database that is not clustered works. But when we try to connect to a clustered MonetDB database via Apache Spark, it fails with a "unhandled result type…
user2238704
  • 121
  • 8
0
votes
1 answer

MonetDB simple join performance on 2 tables

Let's assume I have two tables of the same row count. Both tables contain a column that allows for 1-1 join between them. If those tables were turned into one table instead and thus JOIN statement eliminated from the query, would there be any…
marcin_koss
  • 5,763
  • 10
  • 46
  • 65
0
votes
2 answers

monetdb bulk copy | bulk copy with python

Am facing issue with file loading for bulk import in monetdb table. provided below are details for re creation of issue: I have installed monetdb version 11.19.9 and python client for monetdb is 11.19.9 too. Created dbform and it's working fine, I…
sharafjaffri
  • 2,134
  • 3
  • 30
  • 47
0
votes
1 answer

Monetdb- MonetDB an in-memory database or not?

Is it okay to say that monetdDB is an in-memory database. I read Here that its use array as data storage in memory to perform relational algebra operation. Is it enough to say it is an in-memory database ?
Fopa Léon Constantin
  • 11,863
  • 8
  • 48
  • 82
0
votes
2 answers

Neither of the statistical functions appear to work in MonetDB

When I attempt to run following query on a double column: SELECT stddev_samp(col1) FROM t1 I get: Error: SELECT: no such unary operator 'stddev_samp(double)' SQLState: 22000 ErrorCode: 0 If I run it against an int column, I get: Error: SELECT: no…
user824276
  • 617
  • 1
  • 7
  • 20
0
votes
1 answer

MonetDB, data loss in restart server

I have been using MonetDB in production for some time now, and I have nothing to complain about. My database has tables with more than 30 columns and 30 million records, and I perform analysis through cubes in Pentaho / Saiku. I have restarted the…
Luciano Sasso Vieira Sasso
  • 1
0
votes
2 answers

Is MonetDB using SIMD instructions

I wonder know if MonetDB uses SIMD (Single Instruction Multiple Data) and if not How I can implement it for filtering or aggregation.
GBrian
  • 1,031
  • 11
  • 28
1 2 3
…
29 30