异步物化视图修改active状态失败

删除异步物化视图相关表后按照之前名字重新建了一下,重新建完之后修改异步物化视图状态失败
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

然后现在通过删除重新建的方式处理了,为啥不能直接修改呢