Aman Sinha has posted comments on this change. ( http://gerrit.cloudera.org:8080/17595 )
Change subject: IMPALA-10723: Treat materialized view as a table instead of a view ...................................................................... Patch Set 11: (1 comment) http://gerrit.cloudera.org:8080/#/c/17595/7/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test File testdata/workloads/functional-query/queries/QueryTest/compute-stats.test: http://gerrit.cloudera.org:8080/#/c/17595/7/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test@1841 PS7, Line 1841: table > Yeah, I am considering this too, as what it means to treat MVs as tables. I Adding the MV syntax is not in scope for this patch because the DDLs for MV create/drop/alter are actually done through Hive, not through Impala. That's the reason why in the load script functional_schema_template.sql, it is under the 'CREATE_HIVE' section: +---- CREATE_HIVE +CREATE MATERIALIZED VIEW IF NOT EXISTS {db_name}{db_suffix}.{table_name} In general, MVs are full-ACID tables (although insert-only is also allowed). Impala does not support writing to full-ACID tables but it can read from it. So, the main focus of this patch is to allow read operations on MVs including computing stats. This allows an external frontend to leverage these stats while doing all the complex query rewrite operations and MV refresh (full/incremental based on the delta change in the source tables) via the external frontend. I can clarify this in the commit message in case that would make the scope clearer. -- To view, visit http://gerrit.cloudera.org:8080/17595 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: If3108996124c6544a97fb0c34b6aff5e324a6cff Gerrit-Change-Number: 17595 Gerrit-PatchSet: 11 Gerrit-Owner: Aman Sinha <amsi...@cloudera.com> Gerrit-Reviewer: Aman Sinha <amsi...@cloudera.com> Gerrit-Reviewer: Impala Public Jenkins <impala-public-jenk...@cloudera.com> Gerrit-Reviewer: Qifan Chen <qc...@cloudera.com> Gerrit-Reviewer: Quanlong Huang <huangquanl...@gmail.com> Gerrit-Comment-Date: Wed, 23 Mar 2022 23:08:51 +0000 Gerrit-HasComments: Yes