We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
CREATE TABLE '...' create materialized view mv1 refresh manual as select lo_orderkey, lo_orderdate, lo_linenumber," + " sum(lo_quantity) total_quantity," + " sum(lo_revenue) as total_revenue," + " sum(lo_tax) as total_tax" + " from lineorder" + " group by lo_orderkey, lo_orderdate, lo_linenumber";
query "select lo_orderdate," + " sum(lo_quantity) total_quantity," + " sum(lo_tax) as total_tax" + " from lineorder" + " where lo_orderkey = 100" + " group by lo_orderdate"
the query has been rewritten by mv1 with a projection above mv scan node.
the query has been rewritten by mv1 without a projection above mv scan node.
select current_version()
The text was updated successfully, but these errors were encountered:
Successfully merging a pull request may close this issue.
Steps to reproduce the behavior (Required)
CREATE TABLE '...'
create materialized view mv1
refresh manual
as
select lo_orderkey, lo_orderdate, lo_linenumber," +
" sum(lo_quantity) total_quantity," +
" sum(lo_revenue) as total_revenue," +
" sum(lo_tax) as total_tax" +
" from lineorder" +
" group by lo_orderkey, lo_orderdate, lo_linenumber";
query
"select lo_orderdate," +
" sum(lo_quantity) total_quantity," +
" sum(lo_tax) as total_tax" +
" from lineorder" +
" where lo_orderkey = 100" +
" group by lo_orderdate"
Expected behavior (Required)
the query has been rewritten by mv1 with a projection above mv scan node.
Real behavior (Required)
the query has been rewritten by mv1 without a projection above mv scan node.
StarRocks version (Required)
select current_version()
The text was updated successfully, but these errors were encountered: