cgivre opened a new pull request, #3036:
URL: https://github.com/apache/drill/pull/3036

   # [DRILL-8543](https://issues.apache.org/jira/browse/DRILL-XXXX): Add 
Support for Materialized Views
   
   ## Description
   This PR adds materialized view support to Apache Drill, enabling users to 
store pre-computed query results for improved query performance.
   
     Features
   
     - SQL Commands: CREATE [OR REPLACE] MATERIALIZED VIEW, DROP MATERIALIZED 
VIEW, and REFRESH MATERIALIZED VIEW
     - Query Rewriting: Automatic query optimization using Calcite's 
SubstitutionVisitor to transparently rewrite queries to use materialized views 
when beneficial
     - Parquet Storage: MV data stored as Parquet files for efficient columnar 
access
     - Metastore Integration: Optional synchronization of MV metadata to Drill 
Metastore (Iceberg, RDBMS, MongoDB backends)
   
     Implementation
   
     - New SQL parser classes for MV statements
     - MaterializedView data model with JSON serialization 
(.materialized_view.drill files)
     - MaterializedViewHandler for CREATE/DROP/REFRESH operations
     - MaterializedViewRewriter for query plan substitution
     - DrillMaterializedViewTable implementing Calcite's TranslatableTable
     - Metastore API extensions: MaterializedViews interface and 
MaterializedViewMetadataUnit
     - Iceberg metastore backend implementation for MV metadata
   
     Configuration
   
     - `planner.enable_materialized_view_rewrite` (default: true) - Controls 
automatic query rewriting
   
   ## Documentation
   Added docs/dev/MaterializedViews.md with complete feature documentation
   
   ## Testing
   Added additional unit tests.


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to