[HIVE-14496] Enable Calcite rewriting with materialized views

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.0
• Component/s: Materialized views
• Labels: TODOC2.2
• Assignee: Jesus Camacho Rodriguez
• Reporter: Jesus Camacho Rodriguez
• Created: 09/Aug/16 17:57
• Updated: 02/Sep/17 00:59
• Resolved: 16/Dec/16 13:59

Description

Calcite already supports query rewriting using materialized views. We will use it to support this feature in Hive.

In order to do that, we need to register the existing materialized views with Calcite view service and enable the materialized views rewriting rules.

We should include a HiveConf flag to completely disable query rewriting using materialized views if necessary.

Issue Links

• blocks: HIVE-17432 Enable join and aggregate materialized view rewriting
• incorporates: HIVE-14497 Fine control for using materialized views in rewriting
• links to: RB link