Re: [MonetDB-users] Bulk load to MonetDB

24 Mar 2005

      Hi,

Thanks for your interest in MonetDB.

To load the files, I suggest to create the PostgreSQL load file and 
change it to something like this:

COPY 10000 RECORDS INTO dim0 FROM '/Users/me/path/to/benchw/dim0.dat'
USING DELIMITERS ',';

COPY 10000 RECORDS INTO dim1 FROM '/Users/me/path/to/benchw/dim1.dat'
USING DELIMITERS ',';

COPY 10000 RECORDS INTO dim2 FROM '/Users/me/path/to/benchw/dim2.dat'
USING DELIMITERS ',';

COPY 10000000 RECORDS INTO fact0 FROM '/Users/me/path/to/benchw/fact0.dat'
USING DELIMITERS ',';

COMMIT;

This should work to load the files.

Please feel free to report any problems.

Regards,
Fabian

Juan José van der Linden wrote:
...
Hi,
I've compiled MonetDB and the SQL front-end on my PowerMac 2x2 G5.
I've used fink to install the libraries needed. I would like to perform 
the query test that are available from http://benchw.sourceforge.net .
How can I use the acsii_io module to bulk load the data files from the 
benchw project?
Thanks in advance.
Regards,
Juan José.