[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