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
Create table using description from the file
Case:
I have csv data extract to be loaded with a great COPY INTO and also have a csv file with table description.
I want to create table from this description file before loading data.
Q:Is it possible to create a table by using description file?
I…
Alex O
- 1
- 1
0
votes
1 answer
ZIP support in COPY INTO
Is it possible to add zip support in COPY INTO statements?
It is still most popular compression with best results (in my tests) and widely adopted as default by many vendors.
Alex O
- 1
- 1
0
votes
1 answer
Is there any JDBC client SSL/TLS support for MonetDB?
Does anyone know if MonetDB supports encrypted JDBC connections using SSL/TLS? If so, is there a driver that supports it?
David Moyers
- 5
- 1
0
votes
1 answer
Is it possible to open a regular monetdb database directory with monetdb/e?
I'm trying to point monetdb/e to a regular monetdb database directory (version 11.37.7 (Jun2020)) and getting a 254 returned by monetdbe_open().
Is this currently not possible or am I doing something wrong?
Also, is there an IRC channel or…
muhmud
- 4,474
- 2
- 15
- 22
0
votes
1 answer
Is it possible to build monetdb/e as a static library?
Is there an easy way to configure the monetdb cmake build to produce a monetdb/e static library?
muhmud
- 4,474
- 2
- 15
- 22
0
votes
1 answer
How to use Python SQLAlchemy ORM with MonetDB and database schema
I tried and sadly failed to use Python SQLAlchemy ORM with MonetDB and database schema.
A minimal example to demonstrate my problem is the following:
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from…
P. B.
- 587
- 6
- 12
0
votes
2 answers
Is it possible to run a MonetDB cluster on Windows?
It appears that monetdbd is used on Linux based installations to create a multi-node MonetDB cluster. However, monetdbd is not available for Windows. Is there a way to create a MonetDB cluster on multiple Windows hosts without using monetdbd?
David Moyers
- 5
- 1
0
votes
2 answers
Good use case for MonetDB - Star Schema with around 10-15 dimensions with parent/child hierarchies
I have a star schema with:
a fact table with one column per dimension (around 10 to 15 dimensions) and one key figure. Volume would be between 50 million to 100 million records
a table per dimension, each dimension has attributes and can have one…
marcel f
- 288
- 2
- 15
0
votes
2 answers
MonetDB - How to create a new user/role to have full access to the entire DB/schema?
is there a way to create a new admin user/role that can have access to all the existing tables.
If another user create a new table, the admin user should be able to also have permissions to the new table.
Right now, the only way is giving explicitly…
0
votes
1 answer
MonetDB pystethoscope with Python2?
Does the new MonetDB profiler pystethoscope also work with Python 2.6 and up?
Jennie
- 345
- 1
- 8
0
votes
0 answers
Connect to monetDb trough ssh tunnel
I am trying to connect to MonetDb database, unsuccessfully though :(
I am trying to replicate this approach as much as I can.
Here is the code:
var MDB = require('monetdb')();
var Client = require('ssh2').Client;
var ssh = new Client();
const…
Hairi
- 3,318
- 2
- 29
- 68
0
votes
2 answers
How to disable or truncating fields when printing in MonetDB
I tried to query the Monetdb server. I am printing the columns in the table called Ada and the columns are truncated and only few columns are displayed. On the terminal, it says to avoid dropping or truncating the columns use \w-1 but not sure how…
KSp
- 1,199
- 1
- 11
- 29
0
votes
4 answers
How to display all columns and its data type in a table via SQL query
I am trying to print the column names from a table called 'meta' and I need also its data types.
I tried this query
SELECT meta FROM INFORMATION_SCHEMA.TABLES;
but it throws an error saying no information schema available. Could you please help…
KSp
- 1,199
- 1
- 11
- 29
0
votes
1 answer
dockerized java application access a monetdb database which has been deploied on a jupyterhub via docker
There is a monetdb docker deployed on the jupyterhub, I'm developing a Java application which will use the data from the database on the jupyterhub.
Is there a way to write in the code to make the access to the database via internet, so that users…
Wei
- 1
- 1
0
votes
1 answer
How to make alter command take effect In MonetDB?
I use mclient to connect MonetDB and enter this sql:"alter table t1 rename to t2",then I keep this mclient alive and I use anthor mclient to connect the same MonetDB database, but when I enter this sql :"select *from t2 ",MonetDB reports an error :…
