删除异步物化视图相关表后按照之前名字重新建了一下,重新建完之后修改异步物化视图状态失败
alter MATERIALIZED VIEW wl_datawarehouse.dws_order_day_mv ACTIVE
1064 - Unexpected exception: Getting analyzing error. Detail message: Can not active materialized view [dws_order_day_mv] because analyze materialized view define sql:
CREATE MATERIALIZED VIEW dws_order_day_mv
(calday
, wl_center
, sales_dept_code
, sales_dept_name
, region_code
, region_name
, bus_area_code
, bus_area_name
, sold_to_code
, sold_to_name
, ship_to_code
, ship_to_name
, sold_to_province
, sold_to_city
, sold_to_county
, ship_to_province
, ship_to_city
, ship_to_county
, `mater
时间: 0.095s
然后现在通过删除重新建的方式处理了,为啥不能直接修改呢