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

MonetDB connect to GO.db within R code that is run in-database

I am trying to run some R code in database. Most of it is going pretty well, but I seem to have stumbled on a bug. I cannot load the following package, which is a dependency for some of my code. WGCNA I have been chasing it down, and it seems to be…
wligtenberg
  • 7,695
  • 3
  • 22
  • 28
0
votes
1 answer

Can I retrieve the last insert id in monetdb?

I have been querying for the most recent (auto incrementing) ID of a given table I've inserted into (SELECT "id" FROM "my_table" ORDER BY "id" DESC LIMIT 1), but I'm wondering if there exists a more general way to do this, instead.
Luxart
  • 17
  • 2
0
votes
1 answer

Connect to MonetDB via JDBC without specifying database name on Linux

Our Java application works as the following: - it connects to the server without specifying any database name, - checks if the given database exists and creates a new one if not. On Windows, the application works fine but on Linux it cannot connect…
SCS
  • 11
  • 3
0
votes
1 answer

MONETDB unexpected IDENT in: error on insert

I have a table and want to insert some data from a file, but I am getting some very odd error messages, I cant understand CREATE TABLE "MCS_HHGRID_MASTER" ( "FAMSRNO" VARCHAR(7), "PNUM" INT , "PSEX" SMALLINT , "PDOBD" SMALLINT , "PDOBM"…
spuddybike
  • 1
  • 1
0
votes
1 answer

How to create a function with a variable number of columns

In my case, I would like to be able to send multiple columns to an (R) function, however the columns themselves are defined at run time. Even worse, the calculation that has to be performed depends on the data of all columns. (So I cannot execute it…
wligtenberg
  • 7,695
  • 3
  • 22
  • 28
0
votes
1 answer

Most efficient technique to extract data from multiple SQL tables

I have a bit of an issue deciding how to approach a problem- we are using monetDB in combination with a JAVA jdbc program. I would like some guidance if I am able to solve my problem using SQL queries, if I need to write script, or possibly doing my…
Gadesxion
  • 391
  • 2
  • 6
  • 18
0
votes
1 answer

MonetDB delete table fully

I had created some tables in sys. how to delete them fully? can i do that : 1.drop table [your_tablename] 2.delete table [your_tablename] but my teacher told me that is wrong,how should I write a SQL statement? and my MonetDB's version is [MonetDB…
xiang Gao
  • 39
  • 1
  • 6
0
votes
1 answer

Install Monetdb alongside with Postgres

I am not sure if it is the right place to ask but, will it cause problems if I install Monetdb on the ubuntu which already has postgres installed on it? I know it will fight for the system resources, but I mean if it will cause other problems.
Masyaf
  • 843
  • 1
  • 9
  • 17
0
votes
2 answers

MonetDB test client application not linking

I tried to compile test application for MonetDB under Ubuntu 14.04 LTS Trusty Tahr. I followed the download instructions from official site, installation was successful, then I installed a bunch of other packages in order to copmpile it. Now when I…
Ivan Zuboff
  • 47
  • 1
  • 9
0
votes
1 answer

MonetDB - COPY INTO bulk insert with special char \

I'm using COPY INTO to bulk insert some data into MonetDB. The csv that I'm copying from has some special characters like \ in some string fields and it broke the insertion. The error that I got is: Failed to import table line 1 field 11 'clob'…
Saed Hammad
  • 96
  • 10
0
votes
1 answer

monetdb mapi api, mapi_connect() to remote host

For some reason connecting to a setup monetdb server via mapi_connect("localhost", 50000, "monetdb", "monetdb", "sql", "demo"); works, however, mapi_connect("xxx.xxx.xxx.xxx", 50000, "monetdb", "monetdb", "sql", "demo"); Doesn't work. I've checked…
Yuriy Y. Yermilov
  • 133
  • 6
0
votes
1 answer

MonetDB Backups - methodology?

If I have a MonetDB database running on RHEL which is in the region of hundreds of million rows (hundreds of GB) with dozens (but not hundreds) of tables and I'm interested in implementing a decent backup strategy for it, specifically with regards…
3N1GM4
  • 3,372
  • 3
  • 19
  • 40
0
votes
0 answers

DROP SEQUENCE not working on MonetDB

Whenever I try to drop a sequence I get the following error:- DROP SEQUENCE seq_12129; DROP SEQUENCE: unable to drop sequence seq_12129 (there are database objects which depend on it) I have dropped all the tables in the current schema, but I am…
user3517179
  • 31
  • 7
0
votes
1 answer

Is there any way to recover a lost database password?

We have a monetdb database which we can no longer get in to. The password we have recorded and also stored in the user's SQL client no longer works. Is there any way to bypass this and recover the password or the data?
Kev Thorpe
  • 63
  • 2
  • 7
0
votes
1 answer

Monet DB JDBC parallel executeBatch failing

In my application, I want to insert multiple rows in different tables in parallel. For this I am creating prepared statement in each thread and using exceuteBatch with 10K as batch size. I have made auto commit as false. And after each executeBatch,…
Vikas Kumar
  • 17
  • 9
1 2 3
…
29 30