Krisztian Kasa created HIVE-23130: ------------------------------------- Summary: User friendly error message when MV rewriting fails Key: HIVE-23130 URL: https://issues.apache.org/jira/browse/HIVE-23130 Project: Hive Issue Type: Task Components: CBO Reporter: Krisztian Kasa Assignee: Krisztian Kasa
If materialized view rewriting fails because an unsupported SQL clause or operator is used we got an error message like this: {code} FAILED: SemanticException Cannot enable automatic rewriting for materialized view. Unsupported RelNode type HiveSortExchange encountered in the query plan {code} 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. {code} create materialized view cmv_mat_view as select a, b, c from cmv_basetable sort by a; {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)