Hi, Please verify: col1varchar(6) col2 varchar(6) copy select col1,col2 from table1 into 'c:\testfile.csv' using delimiters ','; current version "abc ","def " previous version "abc","def" Why did you change that? Thanks. Dariusz. Sjoerd Mullender wrote:
dariuszs wrote:
Hi, specs: windows server 2003 x64 enterprise, 24GB memory, 1TB storage (sas drives raid 0). MonetDB-SQL-Installer.msi-x86_64-20081111.msi
I've just installed this database so I guess that's the lates version.
Actually, it isn't. The latest version is MonetDB5-SQL-Installer-x86_64-20081216.msi. See http://monetdb.cwi.nl/downloads/Windows/Nov2008-SP1/.
Dariusz.
Stefan Manegold wrote:
Hi,
- How does the server crash, i.e., do you get any error messages either on the mserver5 console or on the mclient side?
- Which version of MonetDB are you using?
- Which OS are you running MonetDB on?
- What kind of hardware (CPU, amount of RAM, amount of swap) do you use?
- Is the HW 32 or 64 bit? If HW is 64 bit, is the OS 32 or 64 bit? If OS is 64 bit, is your MonetDB 32 or 64 bit? If MonetDB is 64 bit, do you use 32-bit OIDs or 64-bit OIDs?
Providing us with the output of
mserver5 --version
should answer most of the above questions about MonetDB.
Stefan
On Thu, Jan 15, 2009 at 09:13:25AM -0500, dariuszs wrote:
Hi, table1 - 1,000,000 records table2 - 300,000 records (from table1) table3 - 400,000 records (from table1)
They key (key27) on all tables is varchar(27) SQL
select count(*) from table1 where key27 in (select key27 from table2, table3); (the answer should be 700,000)
At this point server crashed.
I'm trying to join 3 tables to get a count on table1 only when there is a match in table2 or table3. Could you provide me with a sample how to properly match 3 or more tables based on the match key? Thank you. Dariusz.
Martin Kersten wrote:
dariuszs wrote:
Hi, The SQL server crashes when I try to join 3 tables using 27 bytes key? Can you help me? Thanks. Dariusz.
It would be helpful if you provide a 5 line example that demonstrates the problem.
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users