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
1
vote
1 answer
MonetDB-PHP Error on parameterized query with timestamp
I'm using MonetDB with MonetDB-PHP library.
I have followed the documentation from: https://github.com/MonetDB/MonetDB-PHP
Everything is working fine, but if I set parameter for timestamp type column I get the following error:
Error from MonetDB:…
Dositej
- 13
- 4
1
vote
2 answers
how to update missing records in sequence
i have missing records in a sequence and my current output looks like this
| 1882 | 25548860 | 4 | 30 | null | null |
| 1882 | 25548861 | 4 | 30 | null | null…
kilmonger
- 41
- 7
1
vote
1 answer
GDK reported error: BATproject2: does not match always
The database version we are using is MonetDB 5 server v11.37.7 (Jun2020) on Debian 4.9.210-1+deb9u1.
I have a regular table with about 22M entries. I added a Boolean column with:
alter table conversations add column "virtual" Boolean Null ;
Now…
Christian Candia
- 11
- 1
1
vote
1 answer
Using COPY INTO with a CSV file containing a Timestamp column
I'm trying to import a CSV file using COPY INTO syntax. I have the below table
test(id int, name varchar(50), expi TIMESTAMP)
Here is an extract of my CSV file:
id,name,expi
1,toto,2013-01-14T23:12:34
I did not succeed in providing the format for…
J.M. Kenny
- 384
- 4
- 11
1
vote
2 answers
Cluster configuration on MonetDB: cannot discover other nodes
I have installed and configured a 3 monetdb nodes cluster on 3 virtual machines on my MacBook (Using Oracle Virtual Box). I use MonetDB 5 server 11.37.7
I have followed the Cluster Management documentation of MonetDB, but the monetdb discover…
J.M. Kenny
- 384
- 4
- 11
1
vote
1 answer
Finding key constraints in MonetDB
I am trying to get the key constraints on the table name 'meta'. But the information schema doesn't work and I am new to MonetDB. Is there any way I can find the primary key and foreign key in my table?
The Query I tried:
SELECT *
FROM…
KSp
- 1,199
- 1
- 11
- 29
1
vote
2 answers
Get all columns from a table in Monetdb
I have to study a table on monetdb that probably has many columns.
When I do
SELECT * from cat.data limit 1;
I get
1 tuple !5600 columns dropped!
Which I interpret as not getting all the columns from the console.
I am using mclient to connect to…
Hairi
- 3,318
- 2
- 29
- 68
1
vote
1 answer
Is it possible to directly copy data from Numpy array to MonetDB?
Since Numpy arrays map to C arrays and MonetDB is using C arrays as its storage model, is it possible to load data from in-memory Numpy arrays into MonetDB? This would save a round-trip to disk, i.e. writing the data from the Numpy array to disk and…
sedot
- 577
- 5
- 16
1
vote
0 answers
How to connect to monetdb with perl
I am trying to connect to monetdb with perl code, it hangs. I am not able to connect nor it is throwing an error to get it resolved.
Please find the below code ,
`#!/usr/bin/perl
use DBI();
use POSIX;
print "\nStart a simple Monet MIL…
Gowthami G
- 11
- 2
1
vote
0 answers
Sqlalchemy doesn't seem to manage thread-unsafe monetdb connections very well
As far as my understanding of sqlalchemy goes, if you want to execute database queries from parallel threads in python/sqlalchemy you should use the scoped_session paradigm.
However I have noticed that for the pymonetdb that even using a small…
Yunus King
- 1,141
- 1
- 11
- 23
1
vote
1 answer
Monetdb limit results displayed after query
I would like to know if there is any way of limiting the number of output results in monetdb, like it's done in Oracle for example, using:
.SET RETCANCEL ON
.SET RETLIMIT -1
EDIT: I have found the way of limiting the number of the output rows…
Serhiy
- 4,073
- 3
- 36
- 66
1
vote
1 answer
Linking error using C code to connect to Monetdb
I have tried to compile the code shown here:
But I got a linking error.
I tried the solution mention here.
But again, I got this error:
gcc main.c -I /usr/include/monetdb -lmapi
/usr/lib/gcc/x86_64-linux-gnu/7/../../../../lib/libmapi.so:…
Mahmoud Mohsen
- 71
- 3
1
vote
0 answers
Monet db performance issue while updating data
In monetdb, I have to update data depending on the next row value, For this i have used update query with self join like below. We have almost 1 million records in the table, it is causing the performance issue and breaking down. I used the below…
ABC D
- 11
- 2
1
vote
1 answer
Unable to start monetdb using mserver5
I have an existing monetdb installation and a dbfarm. I want to change the number of threads being used by monetdb as specified in this (https://www.monetdb.org/Documentation/Guide/Multicores) docs page. It looks like we need to start monetdb using…
da4kc0m3dy
- 132
- 1
- 10
1
vote
1 answer
What are the MonetDB equivalents of MySQL's least() and greatest()?
SQL queries reserve the names min() and max() for aggregate functions, leaving DBMSes to make other choices for scalar functions of the same functionality - the minimum or maximum value from a fixed-length list of arguments.
MySQL uses least() and…
einpoklum
- 118,144
- 57
- 340
- 684