Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enabling heuristic optimization #105

Open
niceIrene opened this issue Sep 28, 2023 · 0 comments
Open

Enabling heuristic optimization #105

niceIrene opened this issue Sep 28, 2023 · 0 comments

Comments

@niceIrene
Copy link

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 <QUERY_CONTEXT>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant