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

Return value after insertion - MonetDB/SQL 2003

I am using MonetDB (SQL:2003) and want to get the last inserted row and tried to do the query with OUTPUT. However it failed with syntax error. Query: INSERT INTO MyTable(name, age) OUTPUT INSERTED.* VALUES ('John Doe', 25) Is there any…
harrison
  • 27
  • 1
  • 6
0
votes
2 answers

Importing CSV to MonetDB

I am new for using MonetDB. I have imported .csv file in it. However there are always the problem : sql>COPY INTO 123 FROM' C:\Program Files\MonetDB\112.csv' USING DELIMITERS '|', '|\n' LOCKED; COPY INTO: filename must have absolute path: …
Ada
  • 1
  • 5
0
votes
1 answer

Monetdb database was killed by signal SIGSEGV

I'have a database version MonetDB Database Server Toolkit v1.1 (Jun2016-SP2) working on RHEL version 6.7 I faced with unexpected shut down with the message in the log: "database was killed by signal SIGSEGV" when trying to execute bunch of 'SELECT…
Max Kilovatiy
  • 798
  • 1
  • 11
  • 32
0
votes
2 answers

Show runtime of a query on monetdb

I am testing monetdb for a colunmnar storage. I already installed and run the server but, when I connect to the client and run a query, the response does not show the time to execute the query. I am connecting as: mclient -u monetdb -d voc I…
user3806586
  • 53
  • 9
0
votes
2 answers

PostgreSQL, MonetDB and MySQL add foreign key to existing table

When I add a foreign key to a table that already has data, what does each of these database management systems do? Do they analyze each value of the column to confirm it is a value from the referenced table primary key ? Or do they have some other…
João Amorim
  • 3
  • 4
0
votes
1 answer

First entry and last exit time of a visit which has less than gap 100 seconds

I have a table with entry time, exit time, location id, row num (auto generated),gap(gap from previous visit), final_group (generated value to separate records which has gap>100 seconds). I need to consolidate all the visits which has the gap less…
ABC D
  • 11
  • 2
0
votes
1 answer

Converting a timestamp string to UNIX timestamp in MonetDB

I'd like to convert a timestamp like "2018-02-14 23:59:59" to a UNIX timestamp. I found that the opposite is possible using select sys.epoch(unix_timestamp);. The functions str_to_date, str_to_time or str_to_timestamp are of no help, even if I…
Marcell Bernát
  • 11
  • 1
  • 6
0
votes
1 answer

Start with MonetDB development

I want to integrate features into MonetDB, more specifically into the dictionary part of it. I found some information here, but this is not really elaborate. The concrete feature I want to integrate is secondary in my question here. My biggest…
Bryan Elrod
  • 1
  • 2
0
votes
1 answer

Run different MonetDB databases at same time

I'm trying to run two servers listening to different ports in MonetDB, but I can't configure the ports. I tried to include in M5server.bat: set "mapi_port=50001", set mapi_port=50001, set port=50001, any combination of set and port, basically, still…
Letícia Torres
  • 21
  • 1
0
votes
1 answer

monetdb set identifier as quoted

I want to get Identifiers with quotes in monetdb. Say I have a Table tableA which has two columns ColumnA and ColumnB. I want the quote to be set dynamically. if my ColumnA is quoted and columnB is not it should add quotes for ColumnB. select…
ram
  • 323
  • 4
  • 12
0
votes
1 answer

monetdb incorrect data insert/update

I am using MonetDB to store and analyze email campaign data. I have one table with about 6 million data. Table has around 30 columns. When I select some of the data, I realise that data are not correctly inserted/updated. When I fire "select…
Naisarg Patel
  • 41
  • 4
0
votes
1 answer

MonetDB - Table added to merge table multiple times, can't remove or drop it

I have a MonetDB merge table with about 620 million rows of data in it, let's call it merge_table. It has 14 member tables, each containing some monthly data (e.g. data1701 for January 2017). The Java program that handles loading data into the…
Marcell Bernát
  • 11
  • 1
  • 6
0
votes
2 answers

MonetDB Query Plan

I have a few queries that I am running and I would like to view some sort of query plan for a given query. When I add "explain" before the query, I get a long (~4,000 lines) result that is not possible to interpret.
agg212
  • 407
  • 1
  • 4
  • 17
0
votes
1 answer

Administrator Panel for express MonetDB application

I have an express application that is linked to a Monet database. I need to have an administrator panel to monitor the app and see any changes in the database. Can I use some admin panels like the ones that are available on Rails (ActiveAdmin), or…
Abdelghafour Mourchid
  • 33
  • 6
0
votes
1 answer

Handling Python UDFs in MonetDB

The blending of Python and SQL in MonetDB is a great start to move a lot of the business logic into the database server. However, the current documentation contains some hurdles to take by a novice in this game. Consider the following…
mkersten
  • 694
  • 3
  • 7
1 2 3
…
29 30