January 2012 - users-list

[MonetDB-users] how to load NaN as REAL
by bigu 10 Jan '12

10 Jan '12

I have a csv file and some columns are defined as REAL. The values some time have 'NaN' so when trying to load in the db it says cannot load NaN into REAL. COPY 1000000 OFFSET 2 RECORDS into mytable from 'C:\temp.csv' delimiters ',', '\n'; SQLException:importTable:value 'NaN' from line 11 field 10 not inserted, expecting type real failed to import table -- View this message in context: http://old.nabble.com/how-to-load-NaN-as-REAL-tp33107777p33107777.html Sent from the monetdb-users … [View More]

3 2

[MonetDB-users] load CSV without header row
by bigu 09 Jan '12

09 Jan '12

Today installed monetdb for first time and wanted to play with some of the features but stuck with loading the file. Excuse me if this looks too basic. There is a 3GB csv file (1M rows and 400 columns). I am trying load in monetdb on my windows 7 machine. I first created a table mostly data is numeric exect for few that are metadata strings. How do i load this file without removing the header. The error says column_name not of type integer since the column_name is the actual header string but … [View More]

2 2

[MonetDB-users] [PATCH]: python-monetdb does not support RIPEMD160
by W-Mark Kubacki 09 Jan '12

09 Jan '12

Hello! Although MonetDB supports RIPEMD160, python-monetdb (version 11.5.9) does not. Patch [1] fixes that. Unfortunately Python's hashlib.algorithms and dir(hashlib) is "incomplete" in this regards and lists only algorithms which are guaranteed to be supported. Yet more are actually implemented. The patch moves the responsibility for checking whether RIPEMD160 (and others) is supported to hashlib, retaining the NotSupportedError. -- Mark Kubacki [1] https://raw.github.com/wmark/ossdl-overlay/master/dev-python/python-monetdb…

2 1

[MonetDB-users] Max Connection Limit
by Joseph Brower 06 Jan '12

06 Jan '12

Right now we are hitting the limit of 64 connections to MonetDB. We're working on some middleware that will consolidate those into only 2 or 3 connections, but until we finish it, we need to increase the limit. How do we go about doing that? Thanks, Joseph Brower

3 7

[MonetDB-users] Error in SELECT from a function via Mapi
by Iain Buchanan 02 Jan '12

02 Jan '12

Hi, I'm having problems calling a function via the Mapi interface (using Visual C++ under Windows and the 15th November download). It works fine when I call it directly, but fails when I call via Mapi. I create the function: create function tick.dummy(a integer) returns table (entry integer) begin return (select 1); end; I can then call this directly from mclient without any problems: sql>select entry from tick.dummy(1); +-------+ | entry | +=======+ | 1 | +------… [View More]

1 0

[MonetDB-users] ENUM style table with JOIN versus automatically deduplicated VARCHAR
by Stefan de Konink 02 Jan '12

02 Jan '12

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi, MonetDB 'deduplicates' strings, is there any benchmark that outlines the performance difference of an ENUM with a low number of (string)items versus the use of a VARCHAR field? The technical question would be; Is it more efficient to do: select * from my_table, my_enum where mytable.my_enum_id = my_enum.id and my_enum.name = 'Something'; or select * from my_table where my_enum_varchar = 'something'; I can imagine that the following … [View More]

2 1