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

Error (Hung process?) when using COPY INTO with ANSI file

I'm trying to load a set of public flat files (using COPY INTO from Python) - that apparently are saved in ANSI format. Some of the files load with no issue, but there is at least one case where the COPY INTO statement hangs (no error is returned,…
tylerc
  • 1
0
votes
2 answers

Problems debugging mserver5

I have recently started debugging the mserver5 application using vscode and a very comfy plugin for cmake called CMake Tools. Moreover, I am using gcc 9.3.0 (Ubuntu 9.3.0-17ubuntu1~20.04) as a compiler together with the following launch.json debug…
mledl
  • 13
  • 5
0
votes
0 answers

Using MonetDB grouping sets with Pentaho Mondrian

I know MonetDB supports grouping sets. I also know that Mondrian supports them too, but only in a couple of databases. Is it possible to enable SQL groupings sets in Mondrian for MonetDB database? Thank you!
Llorieb
  • 25
  • 5
0
votes
1 answer

Sqoop Import failing to import data from Monet DB

Sqoop import command failing with error - Could not load db driver class: nl.cwi.monetdb.jdbc.MonetDriver Sqoop Command sqoop import \ --driver nl.cwi.monetdb.jdbc.MonetDriver \ --connect "jdbc:monetdb://host:port/service" \ --username …
Vijiy
  • 1,187
  • 6
  • 21
0
votes
1 answer

Can several threads each open their own DB connection in Monetdbe

I am embedding Monetdbe into a multi-threaded C++ application. I have several threads running on the server-side of my application and each thread opens its own instance of the same Monetdb database, i.e. each thread runs the following…
arif saeed
  • 33
  • 4
0
votes
1 answer

monetdb - Row count is increasing in the target table

I am loading data from SQL server DB table to MonetDB table using spark job. My source table has 100000 records. I am directly moving these records into monetdb table and no filter and joins at all. But once job completed I am seeing 279997 records…
Narasimha Malreddy
  • 1
0
votes
1 answer

Querying available (global) variables in MonetDB

Is there a way to query all the available global variables, such as current_schema, current_user, in MonetDB?
Jennie
  • 345
  • 1
  • 8
0
votes
0 answers

Monet DB server start up error BBPcheckbats: cannot stat file

Am using monet DB version v 2.0.I uploaded a pipe delimited csv file into monet DB uing copy into and it completed successfully.However when I tried the query "select * from table limit 10;" it threw an error saying sys.column not found.I stopped…
prashanth
  • 1
0
votes
1 answer

"Error loading data: 42000" in Pentaho PDI MonetDB bulk Loader step

I want to insert data from a large CSV file to MonetDB. I can't use MonetDB "mclient" because this procedure must run inside a Pentaho Server application within a Docker container. MonetDB is inside a Docker container too. Here's my very simple…
Llorieb
  • 25
  • 5
0
votes
1 answer

How to get detailed error msg from monetdbe_query

Looking at the C examples for monetdbe_query in the GitHub repository: https://github.com/MonetDBSolutions/monetdbe-examples The prescribed way to run queries is to run SQL queries in an IF statement that captures Null return values as shown…
arif saeed
  • 33
  • 4
0
votes
1 answer

Is there a bulk load option from an array into MonetDBe

I am implementing MonetDBe as an integrated DB in my server. I want to have the ability to load bulk data into the database. Looking at the MonetDB documentation there is a CopyInto SQL command that allows the loading of bulk data from csv files. As…
arif saeed
  • 33
  • 4
0
votes
1 answer

How do you use the JIT C/C++ UDF in MonetDB

I am new to MonetDB, and want to write an SQL query in C++ that includes a C++ function as shown in the link below, but I'm not sure how to actually do this. https://www.monetdb.org/index.php/blog/JIT_C_C%252B%252B_UDFs_in_MonetDB If I set up an…
arif saeed
  • 33
  • 4
0
votes
1 answer

How to implement SUM aggregation for strings

We're using MonetDB to implemnent an idea. For our purposes we need to implement the SUM Aggregation for Strings. My first step in trying to realize it was to just add a sum pattern in the mal files that define these patterns for the other…
Moorts
  • 15
  • 1
  • 4
0
votes
1 answer

Does percent_rank() analytic function return correct output for rows in partition

Consider the below query which is based on sample VOC dataset provided by MonetDB. I am trying to find the percent_rank() over partition by trip. SELECT number, trip, tonnage, departure_Date, arrival_date, RANK() OVER ( PARTITION BY trip ORDER BY…
ajaykr11cs
  • 3
  • 4
0
votes
1 answer

monetdb: properly creating and setting the configuration file .monetdb for a user other than monetdb

My goal is to connect to a newly created database named mydb through a new user named jpriest instead of the default user monetdb. Following this question monetdb: switch off password on mclient and the answer provided, I configured a .monetdb file…
inpap
  • 365
  • 3
  • 12
1 2 3
…
29 30