Monetdb user-defined optimizer pipeline
Hi, I was measuring the execution time of some queries using different optimizers that provides MonetDB (minimal, default, no_mitosis, sequential and recycler). Now I want to measure these times but using user-defined optimizer pipeline For this I am testing with the following command: MonetDB Septemberoptpipe='optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.garbageCollector();' tesisdb According to the documentation that would be equivalent to using minimal_pipe, the fact is that when I use the expressed command above and run the query throws me the following error: Function '@ 7 ?.' not defined I wonder if someone has happened something like this or have any idea how to create different pipes to those provided by the system Thanks in advance
Sorry, the previous message had an errror I was measuring the execution time of some queries using different optimizers that provides MonetDB (minimal, default, no_mitosis, sequential and recycler). Now I want to measure these times but using user-defined optimizer pipeline For this I am testing with the following command: monetdb set optpipe='optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.garbageCollector();' tesisdb According to the documentation that would be equivalent to using minimal_pipe, the fact is that when I use the expressed command above and run the query throws me the following error: Function '@ 7 ?.' not defined I wonder if someone has happened something like this or have any idea how to create different pipes to those provided by the system Thanks in advance 2014-12-23 13:51 GMT-04:30 Jose Noel Mendoza Bastidas <08-10734@usb.ve>:
Hi,
I was measuring the execution time of some queries using different optimizers that provides MonetDB (minimal, default, no_mitosis, sequential and recycler).
Now I want to measure these times but using user-defined optimizer pipeline
For this I am testing with the following command:
MonetDB Septemberoptpipe='optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.garbageCollector();' tesisdb
According to the documentation that would be equivalent to using minimal_pipe, the fact is that when I use the expressed command above and run the query throws me the following error:
Function '@ 7 ?.' not defined
I wonder if someone has happened something like this or have any idea how to create different pipes to those provided by the system
Thanks in advance
On 23/12/14 19:21, Jose Noel Mendoza Bastidas wrote:
Hi,
Hi
I was measuring the execution time of some queries using different optimizers that provides MonetDB (minimal, default, no_mitosis, sequential and recycler).
Now I want to measure these times but using user-defined optimizer pipeline
For this I am testing with the following command:
MonetDB Septemberoptpipe='optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.garbageCollector();' tesisdb ^^^^^^ ^^^^^^^^^^^^^^^ unkown command line arguments, perhaps a local script?
mclient -d demo Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.20.0 (unreleased), 'mapi:monetdb://vienna.ins.cwi.nl:50000/demo' Type \q to quit, \? for a list of available commands auto commit mode: on sql>set optimizer='optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.garbageCollector();'; operation successful (0.837ms) sql>
sets the optimizer pipe for the current client session. regards, Martin
According to the documentation that would be equivalent to using minimal_pipe, the fact is that when I use the expressed command above and run the query throws me the following error:
Function '@ 7 ?.' not defined
I wonder if someone has happened something like this or have any idea how to create different pipes to those provided by the system
Thanks in advance
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Jose Noel Mendoza Bastidas
-
Martin Kersten