seawinde opened a new pull request, #28064: URL: https://github.com/apache/doris/pull/28064
## Proposed changes **Function 1** check the select query plan is contain the stmt as following or not > SELECT > [hint_statement, ...] > [ALL | DISTINCT | DISTINCTROW | ALL EXCEPT ( col_name1 [, col_name2, col_name3, ...] )] > elect_expr [, select_expr ...] > [FROM table_references > PARTITION partition_list] > [TABLET tabletid_list] > [TABLESAMPLE sample_value [ROWS | PERCENT] > [REPEATABLE pos_seek]] > [WHERE where_condition] > [GROUP BY [GROUPING SETS | ROLLUP | CUBE] {col_name | expr | position}] > [HAVING where_condition] > [ORDER BY {col_name | expr | position} > [ASC | DESC], ...] > [LIMIT {[offset,] row_count | row_count OFFSET offset}] > [INTO OUTFILE 'file_name'] > if analyzedPlan contains the stmt as following: > PARTITION partition_list] > [TABLET tabletid_list] or > [TABLESAMPLE sample_value [ROWS | PERCENT] > [REPEATABLE pos_seek]] this method will return true. **Function 2** > Get related base table info which materialized view plan column reference, > input param plan should be rewritten plan that sub query should be eliminated ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org