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
Is there a way to get FIND_IN_SET functionality in MonetDB
I am migrating some of my workflows from MySQL to MonetDB.
One thing that has hampered my progress so far is the lack of FIND_IN_SET functionality in MonetDB:
> SELECT FIND_IN_SET('b', 'a,b,c,d');
2
I was relying on this functionality for…
ostrokach
- 17,993
- 11
- 78
- 90
0
votes
0 answers
ADO.NET or OLE DB for MonetDB
I am looking for either ADO.NET (ActiveX Data Objects) or native OLE DB (Object Linking and Embedding, Database) provider for MonetDB. - https://www.monetdb.org/
I am trying to access MonetDB from within MS Analytical services, but SSAS does not…
x Zanon
- 11
- 1
0
votes
1 answer
MonetDB is timestamp guaranteed to be unique
The temporal definition in MonetDB says that:
"TIMESTAMP [ '(' posint ')' ] date concatenated with unique time, precision"
That this mean that if two rows are created with a DEFAULT TIMESTAMP that these timestamps are guaranteed to be unique, even…
kenwri
- 1
0
votes
0 answers
Does monetdb support cursors?
My boss wants me to use monetdb to do some tasks.
But I've found many documents and still not sure whether the
newest version of monetdb support cursors?
if monetdb supports, could you give me an example about how to use it
such as fetching rows,…
shabao
- 11
- 4
0
votes
1 answer
Run two MonetDB databases simoultaneously in Windows
I'm trying to run two MonetDB databases simoultaneously in Windows.
I changed the database name in M5server.bat to mydb, and added -database=mydb to mclient.bat
Then I copied the M5server.bat file and changed the farm to mydb2. I also copied the…
ps0604
- 1,227
- 23
- 133
- 330
0
votes
1 answer
How to start monetdbd from other process (node.js)?
I'm trying to start monetdbd from node like
var exec = require('child_process').exec;
exec('monetdbd start ~/my-dbfarm/');
But it stops runing my code after exec(...).
redexp
- 4,765
- 7
- 25
- 37
0
votes
1 answer
Monetdb bind function Parameters
I am trying to understand the MAL statements for joining three tables. I came across the bind function in MAL statement. I have a table
named lineitem with l_quantity in it. So what does the following statements mean?
( X_94:bat[:oid,:oid],…
Pradeep
- 23
- 8
0
votes
1 answer
How to monetdb log settings (merovingian.log)
How to MonetDB log settings.
I want to change the log level of "merovingian.log".
I want to output the ERROR and WARN the merovingian.log.
But now merovingian.log is outputting only MSG log.
2016-07-22 18:12:03 MSG merovingian[7825]: proxying client…
tthr
- 3
- 1
0
votes
1 answer
How to find Intrumentation in Monetdb
How can I get instumemtation in monetdb ? I need thedetails like planning time , execution time for each MAL statement in monetdb . Is there any command for it ?
Pradeep
- 23
- 8
0
votes
1 answer
How to implement a top n filter in Monetdb?
I want to do a top 10 filter like this:
SELECT t0."A" AS d0,
t0."B" AS d1,
t0."C" AS d2,
t0."D" AS d3,
SUM(t0."SA") AS m0,
SUM(t0."SB") AS m1
FROM "mock_table_1" AS t0
INNER JOIN ( //the top 10 filter begin here
SELECT…
luochen1990
- 3,689
- 1
- 22
- 37
0
votes
1 answer
Executing mySQL queries in R with MonetDB
I am new to SQL and am using MonetDB to load a large file into R studio. I have loaded my data as a db using monetDB, and would now like to execute the R code below on the data in this database:
my_selection <- db_data %>% group_by(id) %>%
…
user5057431
0
votes
1 answer
monetb: what does bind function does with access argument?
I am looking into the MAL code of an execution plan for a query. Can anyone explain what the bind function does in detail?
Specifically, what does the following MAL statements actually do?
X_6:bat[:oid,:int] :=…
Pradeep
- 23
- 8
0
votes
1 answer
Is there a way to view MonetDB Function signatures
I have tried to locate a source for MonetDB function signatures.
Some can be found by querying the sys.functions table, but date and time functions are missing the signatures.
for instance if you look at the "month" function in that table there are…
Keeper of the Grove
- 140
- 9
0
votes
0 answers
Monetdb.read.csv error in importing .csv file to a new monetdb table
I am trying to import in a table a large csv file to monetdb. I am using monetdb.R to so.
monetdb.read.csv(conn, file="C:/CoreData/data_master.csv", "coredata", 1000, delim=",")
However I get the following error:
Error in .local(conn, statement,…
Michalis
- 21
- 2
0
votes
1 answer
Encrypting MonetDB Database
I'm using a monetdb database to store massive amounts of sensor data such as data from accelerometers and gyroscopes. Now I need to restrict the access to the data. To restrict the access through the database interface (by use of SQL) I created a…
Frank
- 98
- 5