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
Lazy Logical Replication - wlr.replicate error
I am attempting to setup LLR on MonetDB. Starting the master (named monet-db-0-tenant) works fine, but when I attempt to clone a replica (named monet-db-1-tenant) using wlr.replicate, I receive the error: "Timestamp (monet-db-0-tenant) has incorrect…
David Moyers
- 5
- 1
0
votes
1 answer
Is there a functon similar to DateDiff in MonetDB which can calculate number of weeks between two dates
Consider two dates, "01-Jan-2011' & '01-Oct-2011'.
I wish to calculate number of weeks in between these dates.
I have tried the following:
select extract ( week from ( (current_date+ interval '5' day) - current_date ));
It returns error " no such…
ajaykr11cs
- 3
- 4
0
votes
1 answer
monetdbe: multiple connections reading vs writing
I am finding that with monetdbe (embedded, Python), I can import data to two tables simultaneously from two processes, but I can't do two SELECT queries.
For example, if I run this in Bash:
(python stdinquery.py < sql_examples/wind.sql &); (python…
dcc310
- 1,038
- 1
- 9
- 13
0
votes
2 answers
SQL UPDATE-with-Join in MonetDB
I'm using MonetDB 11.33.3 (April 2019 release). I want to update records in some table, using corresponding values from another table.
Specifically, and for example, suppose table1 has columns col1, col3 and table2 has columns col2, col4. Assume…
einpoklum
- 118,144
- 57
- 340
- 684
0
votes
1 answer
MonetDB "server requires unknown hash"
I built MonetDB from source. After I unpack the tarball, I followed these steps:
mkdir build
cd build
cmake ..
make
sudo make install
I was able to install monetdbd and mclient, and they are both at version 11.39.7.
However, when I follow the…
Zhilei Zheng
- 3
- 1
0
votes
1 answer
Why I can't use the function predefined?
I want to use the optimizer_stats function like:
select optimizer_stats();
And it returns
SELECT: no such operator 'optimizer_stats'
But I can find it in the sys.functions table (id=5976).
Also I find the UDF like reverse(string) can't be used…
Alan
- 3
- 2
0
votes
3 answers
Something about the optimizer
I create a database and connect with it. But when I execute
select optimizer;
it returns
SELECT: identifier 'optimizer' unknown
What's the problem with it? And I can't find the sys table in the database using \d.
If I want to add an optimizer…
Alan
- 3
- 2
0
votes
0 answers
Is it possible to implement row-level security in MonetDB?
I'd like to use MonetDB for analytic reports on big data sets that automatically triggers requirements to have row-level security (RLS) based on user provision.
I attempted to use views with functions but MonetDB still requires the same user…
Alex O
- 1
- 1
0
votes
0 answers
How to make DELETE faster in fast changing (DELSERT) table in MonetDB?
I am using MonetDB (MDB) for OLAP queries. I am storing source data in PostgreSQL (PGSQL) and syncing it with MonetDB in batches written in Python.
In PGSQL there is a wide table with ID (non-unique) and few columns. Every few seconds Python script…
Vojtěch Kurka
- 51
- 1
- 6
0
votes
1 answer
MonetDB set specific embedded python version
In a Linux environment, I'd like to be able to set the embedded python3 to a specific python version. My current monetDB install seems to use 3.7 even though all default python paths point to 3.8.6.
Is there a way to set my 3.8.6 install as the…
Parker Johnson
- 3
- 2
0
votes
1 answer
MonetDB Full Disk How To Manually Free Space
My question is similar to this one, essentially I forgot a clause in a join when using MonetDB that produced an enormous result that filled the disk on my computer. Monetdb didn't clean up after this and despite freeing space and waiting 24 hours…
James Scott
- 1,032
- 1
- 10
- 17
0
votes
1 answer
How to insert the character described in the question's body in monetdb without it being transformed to Â+itself ? (MonetDB Server Toolkit v11.39.5)
Inserting in any table in monetdb v11.39.5 inserts  in its place. Apparently the character is not shown well here. The character is a failed attempt at writing "€". It shows as \200 in Emacs and as a square with numbers in it in Eclipse and…
laurent-lesterpt
- 1
- 2
0
votes
1 answer
MonetDB performance adding a new column into an existing table with thousen of columns
I need to add 100 columns into an existing table with 20000 columns in MonetDB, and each alter table command takes 10 seconds.
ALTER TABLE [MYSCHEMA].[MYTABLE] ADD COLUMN [MYCOLUMN] [TYPE] NULL; x100
The total process takes 1000 seconds to peform…
user1700014
- 31
- 2
0
votes
0 answers
MonetDB Mapi Library Data Insertion
void * Data [NUM_ROW][NUM_COLS];
string insertTablePrepare = "INSERT INTO temp VALUES(";
for (size_t k = 0; k < NUM_COLS; k++) {
insertTablePrepare += "?";
if (k==NUM_COLS-1) continue;
insertTablePrepare +=…
ccm
- 25
- 4
0
votes
2 answers
COPY INTO: insufficient privileges: COPY INTO from .. LOCKED requires tables without indices - MonetDB
I am trying to load the data into the tables but i get this error: "COPY INTO: insufficient privileges: COPY INTO from .. LOCKED requires tables without indices"
The code I use to create the table:
CREATE TABLE region (
r_regionkey INT NOT…
