[HIVE-23130] User friendly error message when MV rewriting fails

• Type: Task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 02/Apr/20 09:28
• Updated: 27/Feb/24 22:23
• Resolved: 03/Apr/20 23:28

Description

If materialized view rewriting fails because an unsupported SQL clause or operator is used we got an error message like this:

FAILED: SemanticException Cannot enable automatic rewriting for materialized view. Unsupported RelNode type HiveSortExchange encountered in the query plan

This refers to the HiveSortExchange operator. This is introduced to CBO plan if the statement has sort by clause which may not clear for the user.

create materialized view cmv_mat_view as select a, b, c from cmv_basetable sort by a;

Issue Links

• is related to: HIVE-22785 Update/delete/merge statements not optimized through CBO
• links to: Review Board