Pranav Vaidya wrote:
Hi,
I am new to MonetDB and I am trying to run the TPC-H benchmarks and I was able to successfully load and execute the benchmarks in MonetDB version 4. I also verified whether the tables were populated using Dbvis. However, what seems to fail is the lack of a function called optimizer_stats() in the run.all script.
Is this a procedure or a function defined additionally which is needed. And why is it not present ? Do I need to run some additional scripts to have this run.all script go through successfully without any errors.
Thanks and Regards, Pranav.
Hello, you don't need this call per se. It can be removed from the queries. Alternatively, you can find the optimizer_stats script in sql/src/sql directory. Just run it once against your server is sufficient to make this function known. regards, good luck, Martin