IITDBGroup / gprom

GProM is a middleware that adds support for provenance to database backends.
http://www.cs.iit.edu/%7edbgroup/research/gprom.php
Apache License 2.0
8 stars 5 forks source link

Enabling heuristic optimization #105

Open niceIrene opened 9 months ago

niceIrene commented 9 months ago

According to this paper: Provenance-aware Query Optimization Heuristic optimization is important in improving the performance of TPC-H queries. I tried to enable it by setting this parameter as True: -heuristic_opt DEFAULT VALUE: FALSE ACTUAL VALUE: FALSE Activate heuristic relational algebra optimization However, it gave the following error, which looks like operators in the queries such as *sum(l_extendedprice (1 - l_discount))** caused the error.

ERROR (exception.c:145) exception was thrown (RECOVERABLE) operator_optimizer.c - 143 - <failed assertion: checkModel((QueryOperator *) rewrittenTree)

Error occured (operator_optimizer.c:143) failed assertion: checkModel((QueryOperator *) rewrittenTree) ABORT BASED ON EXCEPTION wipe