[MonetDB-users] Bulk load to MonetDB
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é.
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é.
participants (2)
-
Fabian
-
Juan José van der Linden