March 2009 - users-list

[MonetDB-users] monetdb output mode -f
by Maria 25 Mar '09

25 Mar '09

Hi, I would like to run query with out printing output in order to monitor its performance. I tried to use '-f none' in command-line, but it didn't work for monetdb5. (I am not using xquery here) > ./mclient -lsql -uxman -ddemo -t -f none 1.sql ===> then, it prints all the results on the screen and display time. I want it only display time, not the query results. I also tried to redirect using /dev/null. In this case, it didn't display time. Isn't the '-f none' working in monetdb5?? If so, how can I measure the query time ? Thanks in advance. Maria.

2 1

[MonetDB-users] R6031
by dariuszs 25 Mar '09

25 Mar '09

Hi, I've got this messages while executing 'copy... into...' runtime error R6031 Attempt to initialize CRT more than once What does it mean? Thanks. Dariusz.

2 2

[MonetDB-users] Combined table is not really combined after all
by Yue Sheng 25 Mar '09

25 Mar '09

two tables: table_1 and table_2 both have exactly the same schema. table_1 has 2.15MM rows of data, table_2 has 3.35MM row of data. No indexing created a new table: table_combined using same schema as table_1 insert into table_combined select * from table_1; (30 minutes later) insert into table_combined select * from table_2; (40 minutes later) select count(*) * 1 from table_combined; this give ONLY 2.15MM rows with same rows as table_1 What happened to table_2?!? Yes, I've check dfarm size. It equals 2*(table_1 + table_2 ) So it's there but "just not seeing it"

5 14

Re: [MonetDB-users] Combined table is not really combined after all
by Jens Oehlschlägel 23 Mar '09

23 Mar '09

Yue, > select count(*) from table_combined; What do you get if you update one of your double columns to 1.0 and do a SUM() over this column? Jens

2 1

[MonetDB-users] Adding interval month problem
by Alfred Nordman 23 Mar '09

23 Mar '09

Hi, Consider the following table: create table "table1" ("Pdate" timestamp, "Price" double); insert into "table1" values ('2007-04-21 00:00:00.000000', 7555); insert into "table1" values ('2007-04-22 00:00:00.000000', 7834); insert into "table1" values ('2007-04-23 00:00:00.000000', 5631); insert into "table1" values ('2007-04-24 00:00:00.000000', 7555); insert into "table1" values ('2007-04-25 00:00:00.000000', 7555); I tried using the following query: SELECT ("table1"."Pdate") AS "PurchaseaDate", ("table1"."Pdate" + interval '1' month) AS "PurchaseaDate2", ("table1"."Price") AS "Price" FROM "table1" And got the error: !TypeException:user.s6_2[19]:'mtime.addmonths' undefined in: _61:any := mtime.addmonths(_59:timestamp, A0:int) !TypeException:user.s6_2[20]:'bat.insert' undefined in: _62:any := bat.insert(_53:bat[:oid,:timestamp], _58:oid, _61:any) Any ideas? Thanks, Alfred. -- View this message in context: http://www.nabble.com/Adding-interval-month-problem-tp22657190p22657190.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] sql characters
by dariuszs 22 Mar '09

22 Mar '09

Hi, How do I insert this value into a varchar(20) column? I get an error. "MERS'' Thanks. Dariusz.

3 6

[MonetDB-users] Row_Number() over problem
by Alfred Nordman 22 Mar '09

22 Mar '09

Hi, Given the following table: create table "table1" (col1 varchar(20), col2 int) insert into "table1" values ('a1', 1) insert into "table1" values ('a2', 3) insert into "table1" values ('a3', 5) insert into "table1" values ('a4', 6) insert into "table1" values ('a5', 3) insert into "table1" values ('a6', 7) The following query: select col1, "SumCol2", "rank" from ( select col1, "SumCol2", (row_number() over(order by "SumCol2")) as "rank" from ( select col1, (sum(col2)) as "SumCol2" from "table1" group by col1) as "temp1") as "temp2" Results: col1 SumCol2 rank a1 1 1 a2 3 3 a3 5 4 a4 6 5 a5 3 2 a6 7 6 This is good result set. But if one adds this query a where clause that involves the rank column, empty result set is returned. Example: select col1, "SumCol2", "rank" from ( select col1, "SumCol2", (row_number() over(order by "SumCol2")) as "rank" from ( select col1, (sum(col2)) as "SumCol2" from "table1" group by col1) as "temp1") as "temp2" where rank = 1 any ideas? Thanks Alfred -- View this message in context: http://www.nabble.com/Row_Number%28%29-over-problem-tp22577176p22577176.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 7

[MonetDB-users] sql characters
by dariuszs 21 Mar '09

21 Mar '09

Hi, How do I insert this value into a varchar(20) column? I get an error. "MERS'' Thanks. Dariusz.

1 0

[MonetDB-users] !FATAL: GDKlockHome: Database lock '.gdk_lock' denied
by Yue Sheng 20 Mar '09

20 Mar '09

System hanged for some reason. Cannot kill the process: user 2389 0.0 0.0 0 0 ?? E 6:33PM 0:00.00 (mserver5) Hence cannot restart server. Short of restarting the whole machine, is there a better way to handle this please?

1 0

[MonetDB-users] SQL DATEADD equivalent
by Yue Sheng 20 Mar '09

20 Mar '09

MonetDB doesn't seem to support DATEADD function. I need it to convert Unix time on-the-fly (700milliion times for each query!) . Could anyone recommend a fast way to do this please? Thanks

4 11