Hi All, I am benchmarking MonetDB against other databases, in special the current version of CitusDB's Postgres, to find out which one is a good fit for our OLAP application. In order to do that, I've decided to use a standard benchmark, TPC-H. However, I did not manage to load the data generated by dbgen (one of the tools included in the benchmark) into MonetDB. Here is the SQL statement I've tried to run:
COPY INTO region FROM '/home/user/tpch/dbgen/region.tbl' USING DELIMITERS '|', '\n' LOCKED;
and it generated an error which says the file could not be found:
could not open file '/home/user/tpch/dbgen/region.tbl': No such file or directory
even though the file exists. I'm running the MonetDB provided in the official repository and the version reported by mclient is:
MonetDB v11.21.19 (Jul2015-SP4)
Any help would be appreciated. -- João Victor Tozatti Risso C3SL - Centro de Computação Científica e Software Livre Universidade Federal do Paraná Please consider using PGP encryption to make our communications more secure. You can find my public key at https://pgp.mit.edu/ | Key ID: 395192B8 If you want to know more about PGP encryption, check the following link: https://emailselfdefense.fsf.org/en/
João, I'm betting that the monetdb process is not running as the user in which your region.tbl file is located within their home, so it doesn't have access. Move the file to /tmp and try again. Bryan -----Original Message----- From: users-list [mailto:users-list-bounces+monetdb=openbi.com@monetdb.org] On Behalf Of João Victor Risso Sent: Thursday, May 19, 2016 11:02 AM To: users-list@monetdb.org Subject: MonetDB cannot find file to load Hi All, I am benchmarking MonetDB against other databases, in special the current version of CitusDB's Postgres, to find out which one is a good fit for our OLAP application. In order to do that, I've decided to use a standard benchmark, TPC-H. However, I did not manage to load the data generated by dbgen (one of the tools included in the benchmark) into MonetDB. Here is the SQL statement I've tried to run:
COPY INTO region FROM '/home/user/tpch/dbgen/region.tbl' USING DELIMITERS '|', '\n' LOCKED;
and it generated an error which says the file could not be found:
could not open file '/home/user/tpch/dbgen/region.tbl': No such file or directory
even though the file exists. I'm running the MonetDB provided in the official repository and the version reported by mclient is:
MonetDB v11.21.19 (Jul2015-SP4)
Any help would be appreciated. -- João Victor Tozatti Risso C3SL - Centro de Computação Científica e Software Livre Universidade Federal do Paraná Please consider using PGP encryption to make our communications more secure. You can find my public key at https://pgp.mit.edu/ | Key ID: 395192B8 If you want to know more about PGP encryption, check the following link: https://emailselfdefense.fsf.org/en/ -- ------------------------------ This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
participants (2)
-
Bryan Senseman -
João Victor Risso