- users-list - monetdb.org

[MonetDB-users] tijah exact matching
by Roy Walter 06 Aug '09

06 Aug '09

Is there a way to force a tijah query to return only exact matches? For example, if I search for "wind farm", as in: ("tijah:queryall[about(., wind farm)]") I get matches for "wind farm", "wind" and "farm" but say I only want matches for "wind farm"? I can of course loop through the result with contains(., "wind farm") to exclude unwanted results but that has performance implications. -- Roy

2 1

[MonetDB-users] Get attribute value as text how?
by Roy Walter 06 Aug '09

06 Aug '09

The following XQuery fragment will add the speakername attribute as an attribute of the tag: {$res/../@speakername}: {$res} becomes: Some text... What I want is: Roy Walter: Some text... How does MonetDB/XQuery handle this? I tried: {xs:string($res/../@speakername)}: {$res} but it errors. -- Roy

2 4

[MonetDB-users] how to read/write blob data ?
by 李坤 04 Aug '09

04 Aug '09

I want to store image files into monetdb sql server. I think there are two approaches to do it: the first one is to store the file's full path in a column with varchar type, the second one is to store the image data in a column with blob type. I don't want to see a lot of small image files in the directory, so I choose the second approach. After reading the monetdb manual, I find some examples like this: sql> insert into t1 values (1, blob '012'); I think this is not enough. I also try to use odbc api to store binary data into monetdb, but failed. So please help me to write the blob data into monetdb, as well as the read operation. Maybe there are other ways I don't know, please tell me, thanks!

2 1

[MonetDB-users] problem in extract second
by fatar fatar 03 Aug '09

03 Aug '09

query: select extract(second from '2009-07-24 16:03:35.0000'); result : 0.00 could you please tell me why the result is zero??? and how can i get more spesific result??? Akses email lebih cepat. Yahoo! menyarankan Anda meng-upgrade browser ke Internet Explorer 8 baru yang dioptimalkan untuk Yahoo! Dapatkan di sini! http://downloads.yahoo.com/id/internetexplorer

1 0

[MonetDB-users] underlying storage
by Mag Gam 01 Aug '09

01 Aug '09

What is the recommended storage for MonetDB? We are planning to buy a Sun storage appliance and were wondering if it would work with MonetDB

4 7

Re: [MonetDB-users] server requires 'SHA512' hash, but client support was not compiled in
by Calum Miller 31 Jul '09

31 Jul '09

Hi, Managed to work around this issue by changing the default hashing algorithm in the configure file from SHA512 to MD. Needed a server rebuild. Calum

2 1

[MonetDB-users] server requires 'SHA512' hash, but client support was not compiled in
by Calum Miller 30 Jul '09

30 Jul '09

Hi, I built monetDb from source on Centos 5.0 but get the following error when I try to connect to the server via "mclient -lsql --time -d demo" server requires 'SHA512' hash, but client support was not compiled in I can't find a reference anywhere on how to resolve this, help much appreciated! Thanks Calum Miller

2 1

[MonetDB-users] Executing tijah query from module fails
by Roy Walter 29 Jul '09

29 Jul '09

[This is a new thread following on from "XRPC issues"] Executing a tijah query in a module from both old and new front ends fails. Using the old front end (\g) produces the following error: xquery>import module namespace test="tj" at "http://localhost:50001/export/tj.xq "; more>execute at {"localhost"} {test:tijahSearch("Heathrow")} more><> doLoopLiftedRPC: error occurred at localhost: MAPI = monetdb@localhost:50000 QUERY = import module namespace test="tj" at "http://localhost:50001/export/tj.x q"; ERROR = !ERROR: HTTP Error Code : 404 Bad Request !ERROR: SOAP Fault Code : env:Sender !ERROR: SOAP Fault Reason: !ERROR: Error occurred during execution. !ERROR: interpret: no matching MIL operator to 'tj_query_handler(bit, BA T[void,BAT], BAT[oid,BAT], BAT[void,BAT], BAT[oid,oid], BAT[oid,BAT], BAT[oid,ln g], BAT[oid,dbl], BAT[oid,str], void)'. !MAYBE YOU MEAN: ! tj_query_handler(bit, BAT[void,BAT], BAT[void,BAT], BAT[void,BAT ], BAT[oid,any], BAT[oid,BAT], BAT[void,lng], BAT[void,dbl], BAT[void,str], BAT[ void,BAT]) : BAT[void,BAT] ! ! !ERROR: CMDhttp_post: operation failed. MAPI = monetdb@localhost:50000 QUERY = import module namespace test="tj" at "http://localhost:50001/export/tj.x q"; ERROR = !ERROR: doLoopLiftedRPC: execution failed at all destinations: !ERROR: localhost: !ERROR: HTTP Error Code : 404 Bad Request !ERROR: SOAP Fault Code : env:Sender !ERROR: SOAP Fault Reason: !ERROR: Error occurred during execution. !ERROR: interpret: no matching MIL operator to 'tj_query_handler(bit, BA T[void,BAT], BAT[oid,BAT], BAT[void,BAT], BAT[oid,oid], BAT[oid,BAT], BAT[oid,ln g], BAT[oid,dbl], BAT[oid,str], void)'. !MAYBE YOU MEAN: ! tj_query_handler(bit, BAT[void,BAT], BAT[void,BAT], BAT[void,BAT ], BAT[oid,any], BAT[oid,BAT], BAT[void,lng], BAT[void,dbl], BAT[void,str], BAT[ void,BAT]) : BAT[void,BAT] ! ! !ERROR: CMDhttp_post: operation failed. !ERROR: !ERROR: xquery> Has anyone succeeded in executing a tijah query from within a module? -- Roy

3 8

[MonetDB-users] massive data loss on stop, start
by Matthew Jones 29 Jul '09

29 Jul '09

I added this information as a comment to bug *2825243* but I'm not sure if it's the same so I thought I'd post it here also to see about getting some feedback: I am experiencing widespread data corruption when restarting the May2009-SP1 MonetDB release also, but mine is much simpler. On 64-bit ubuntu: Linux dsvm01 2.6.24-23-server #1 SMP Wed Apr 1 22:14:30 UTC 2009 x86_64 GNU/Linux With a table defined as follows: CREATE TABLE "tablespace"."test_table" ( "col1" varchar(50), "col2" varchar(50), "col3" varchar(50), "col4" varchar(50), "col5" varchar(50), "col6" int, "col7" timestamp(7), "col8" int, "col9" int, "col10" int ); I imported 20998687 records into this table with all columns populated and ran a couple of queries to check the data: select count(*) from test_table ; [ 20998687 ] select count(*) from test_table where col1 = '' or col2 = '' or col3 = ''; [ 0 ] select max(col7), min(col7) from test_table ; [ 2009-07-25 14:17:15.538000, 2009-07-24 15:29:12.524000 ] During the time I loaded the data and ran these queries I did not restart the database, it had been up for about 3 days I then issued: monetdb stop db and monetdb start db and re-ran the queries: select count(*) from raw_plays ; [ 20998687 ] select count(*) from raw_plays where col1 = '' or col2 = '' or col3 = ''; [ 20852061 ] select max(col7), min(col7) from test_table ; [ 2009-07-25 14:17:15.538000, -1-01-01 00:00:00.000000 ] This is some serious data corruption, I've lost data in the vast majority of these records! 73, Matthew W. Jones (KI4ZIB) http://matburt.net

2 3

[MonetDB-users] Announcement: May2009-SP2 bug fix release
by Sjoerd Mullender 29 Jul '09

29 Jul '09

The MonetDB team at CWI/MonetDB BV is pleased to announce the May 2009-SP2 bug fix release of the MonetDB suite of programs. This is the second bug fix release for the May2009 release. More information on this release can be found at <http://monetdb.cwi.nl/projects/monetdb/Development/Releases/May2009/#May200…>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

1 0