建异步物化视图报错，[S1009] Statement,executeQuery( cannot issue statements that do not produce result sets.
建视图语句如下DROP MATERIALIZED VIEW IF EXISTS dwsdb.dws_async_mv_lgt_sortwh_send_day;
CREATE MATERIALIZED VIEW dwsdb.dws_async_mv_lgt_sortwh_send_day
REFRESH AUTO ON SCHEDULE EVERY 10 MINUTE
PARTITION BY (work_date)
DISTRIBUTED BY HASH(sortwh_id, work_class) BUCKETS 32
PROPERTIES (
"replication_num" = "1",
"storage_medium" = "HDD"
)
AS
SELECT
work_date,
sortwh_id,
sortwh_name,
sortwh_center_id,
sortwh_center_name,
work_class,
week_of_year,
month_of_year,
quarter_of_year,
year_of_year,
COUNT(1) AS packnum_sum
FROM dwddb.dwd_lgt_sortwh_actual_sort_f
GROUP BY
work_date,
sortwh_id,
sortwh_name,
sortwh_center_id,
sortwh_center_name,
work_class,
week_of_year,
month_of_year,
quarter_of_year,
year_of_year; 是什么原因导致，求解如何解决？
