November 2014 - users-list

corrupt catalog Oct 2014
by Pierre-Adrien Coustillas 26 Nov '14

26 Nov '14

Hello, we have again duplicated table on version Oct2014. pcoustillas@ monetdb :~$ mclient lemonde Welcome to mclient , the MonetDB / SQL interactive terminal (Oct2014) Database : MonetDB v11.19.3 (Oct2014), 'mapi : monetdb :// monetdb :50000/ lemonde' Type \q to quit , \? for a list of available commands auto commit mode: on sql >\d src __ at __ lm __visites_ agregees table sys . src __ at __ lm __visites_ agregees is not unique, corrupt catalog ? sql > echo " SELECT … [View More]

2 1

support for window aggregates and window frames ...
by Jay Prasad 24 Nov '14

24 Nov '14

Does MonetDB support window aggregates and window frames? >From the documentation it looks like it supports only window rank functions. Queries of the form: SELECT saleyear, salequarter, sum(saleamount), sum(saleamount) OVER ( PARTITION BY saleyear ORDER BY salequarter ASC) AS partitionedsaleamount FROM ds_1108_null_advent_1580276965 group by saleyear, salequarter; fail with this error: SELECT: function 'sum' not found However, the code seems to include branches that process window … [View More]

1 0

How to use JSON in MonetDB
by Art Apl 24 Nov '14

24 Nov '14

Hello! MonetDB documentation says, that JSON is supported in MonetDB, but I can`t find any example. When I try to implement this query in MonetDB client: json.filter({ "store": { "bicycle": { "color": "red", "price": 19.95 }}},'$') I get this error: syntax error, unexpected IDENT in: "json" THX

2 4

JDBC driver: Statement#setMaxRows()
by Robert Koch 24 Nov '14

24 Nov '14

I have big tables with billions of rows. If I click accidentally on DBVisualizer's data tab, or, if the data tab of a small table is opened and I click on a big table, DBVisualizer tries to retrieve all rows. Then I have to kill DBVisualizer process and/or the DB server process. Answer of DBVisualizer's team: "Hi Robert, It seems like the JDBC driver does not implement the Statement#setMaxRows() method. Please contact your driver developer about this problem." Is the Statement#setMaxRows() method implemented?

2 2

Resource on the PHP API for monetdb
by Leon-Constantin Fopa 24 Nov '14

24 Nov '14

Hi every one, I'm interested in accessing monetdb from a PHP script. Can someone provide me a link on resource with introduce that. The research of the keyword "monetdb" from the the http://php.net website search engine give no related result. thanks in advance, Best regards, Fopa Léon Constantin

3 3

Whicht GUIs/Frontends are you using? / MonetDB support in DBVisualizer
by Robert Koch 24 Nov '14

24 Nov '14

Which tools are you using? As mentioned, I am using DBVisualizer for work with MonetDB. I asked for a better support of MonetDB in DBVisualizer: "MonetDB is the leading open-source, column-oriented, analytical in-memory database. MonetDB's community is growing and MonetDB does not come along with a frontend. It would be great to have a native support out of DBVis." This is the answer: "Hi Robert, We have an open ticket for addressing support for MonetDB in DbVisualizer. Currently the number … [View More]

1 0

JDBC driver: sorting columns? - DatabaseMetaData#getColumns()
by Robert Koch 24 Nov '14

24 Nov '14

I am using DBVisualizer via JDBC to work with MonetDB. When exporting tables with DBVisualizers @export function, columns are sorted alphabetically, which causes problems when LOADING the exported csv into another database, and the import tool is expecting the original order of columns. I wrote to the DBVisualizer team, they answered as follows: "Hi Robert, Export uses the column order reported by the JDBC driver, so please consult your driver developer to see if you can get the driver fixed. … [View More]

2 1

To:11/19/2014 6:25:44 PM 1
by drrock1982 19 Nov '14

19 Nov '14

http://teamspl.com.sg/kq/vzxadbrpevtcdjxfltlghewxx.kyorlorbxfhoubwawxvbtvgf… drrock1982(a)rocketmail.com

1 0

Multithreaded prob
by Doug Service 18 Nov '14

18 Nov '14

I have installed MonetDB and and started using it through MAPI. The documentation indicates that opening multiple connections from separate threads in a single process is supported. I perused the MAPI source and it appears that all of the Monet data structures used are associated with the connection. In our application the threads will be independent and processing similar but unique data sets each with its own connection to the database. No threads will share a database connection nor attempt … [View More]

5 6

CREATE TEMPORARY TABLE WITH DATA seems not working - Jan2014-SP3
by Satoshi Nagayasu 18 Nov '14

18 Nov '14

Hi all, As shown below, despite CREATE TABLE WITH DATA works fine, CREATE TEMPORARY TABLE WITH DATA is not able to create a temp table with data. --------------------------------------------------------- $ mclient mydb Welcome to mclient, the MonetDB/SQL interactive terminal (Jan2014-SP3) Database: MonetDB v11.17.21 (Jan2014-SP3), 'mapi:monetdb://localhost.localdomain:50000/mydb' Type \q to quit, \? for a list of available commands auto commit mode: on sql>CREATE TABLE t2 AS SELECT 1 WITH … [View More]

2 2