November 2014 - users-list

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 of requests for it is low so I cannot say when or if it will happen. Most of the database specific support is expressed in a so called database profile in DbVisualizer. This is a single XML file which defines up to 80% of the functionality for a database. The database profile framework is documented in the users guide and if you are looking for improved MonetDB support I suggest you look into building a database profile for it. http://confluence.dbvis.com/display/UG91/Database+Profiles If you have any related questions please don't hesitate to contact us." I somebody out there, who is interested in MonetDB support in DBVisualizer, willing to build a database profile XML file?

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. More specifically, DbVisualizer uses the column order as reported by the DatabaseMetaData#getColumns() method." If MonetDB JDBC driver is actually sorting columns, could you please return the given order of table columns?

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 to use another threads connection. Does anyone have experience using multiple threads in a single process each accessing a separate database MonetDB MAPI connection they would like to share? Did you have any problems? Doug Service

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 DATA; operation successful (1.143ms) sql>SELECT * FROM t2; +------+ | v | +======+ | 1 | +------+ 1 tuple (0.453ms) sql>CREATE TEMPORARY TABLE t AS SELECT 1 WITH DATA; operation successful (0.985ms) sql>SELECT * FROM t; +---+ | v | +===+ +---+ 0 tuples (0.439ms) sql> --------------------------------------------------------- Is this a bug? or something I misunderstand? Regards, -- NAGAYASU Satoshi <snaga(a)uptime.jp>

2 2

[ftin.india.altair.com] Validate Email
by ashishkumar.singh＠altair.com 17 Nov '14

17 Nov '14

Validate Email Address ====================== Email validation to download secure attachment at ftin.india.altair.com. Please click on the following link to view the message: https://ftin.india.altair.com:8443/validate/eJCZlisrascBO00ffEVsQu/LasnXi5p… Or alternatively, enter this validation codein the browser window where you entered your email address: LasnXi5p0Y6ExdEYOSxmmU This code and link is valid for 20 minutes from the request, until 17:23. Please click on the original link in the message email if the link has expired to request a new validation email.

1 0

Operations on Network Addresses
by Tim Burress 14 Nov '14

14 Nov '14

Hello, I'm a relatively new user and have run into a problem which may just be a misunderstanding. I'm using the Oct2014 version, installed on Fedora 20 from the MonetDB rpm repository. When I try to query a database using inet "containment" operators like << or <<= it seems that the operators are not recognized: sql> select src,dst from raw.ids where src << inet'xxx.xxx.xxx.xxx/27'; SELECT: no such binary operator 'left_shift(inet,inet)' sql> select src,dst from raw.ids where src <<= inet'xxx.xxx.xxx.xxx/27'; syntax error, unexpected '=' in: "select src,dst from raw.ids where src <<=" Other ordinary binary inet operators seem OK: sql> select src,dst from raw.ids where src = inet'xxx.xxx.xxx.xxx'; (prints out table) sql> select src,dst from raw.ids where src < dst; (prints out table) However the documented functions do not seem to be recognized: sql> select masklen(inet'192.168.0.0/24') SELECT: no such unary operator 'masklen(inet)' sql> select netmask(inet'192.168.0.0/24') SELECT: no such unary operator 'netmask(inet)' So it seems that support for network address types is only partially available in this release. Is that normal? Do I need to rebuild from source in order to get them? Thanks! Tim

3 7

Security Precautions Of Using Monet DB
by kannan rbk 13 Nov '14

13 Nov '14

Hi, I am started using of MonetDB in our development environment, we decided to move this to our production environment. Before deploying into production environment, I want to know about existing security vulnerabilities and precautions to be taken care of using MonetDB. I had searched in www.monetdb.org, but I haven't found required things. Could you please suggest me any security advisory documents or help guide? I can't find anything in nvd.nist.gov vulnerability database. -- Regards, Kannan RBK

2 2