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

Reply via email to