云数据仓库ADB创建物化视图怎么报错了吗?
CREATE MATERIALIZED VIEW xianxia.view_bi_sp_d
COMMENT 'BI平台上商品销售d'
REFRESH
START WITH DATE_FORMAT( now() + INTERVAL 1 DAY, '%Y-%m-%d 10:40:00' )
NEXT DATE_FORMAT( now() + INTERVAL 1 DAY, '%Y-%m-%d 10:40:00' )
AS
(
SELECT * FROM xianxia.nol_view_bi_商品销售d
)
> 1815 - [40040, 2023101016532119216813001203453241604] Query execution error: : Failed to create temporary table view_bi_sp_d. Error message: illegal name, pos 656, line 41, column 5, token - DDL:CREATE TABLE xianxia.ctas_temp_2023101016532119216813001203453241604_view_bi_sp_d (
SKU varchar,
店铺编码 varchar,
日期 varchar,
毛销额 double,
毛销量 double,
净销额 double,
净销量 double,
退款额 double,
退货量 double,
换货量 bigint,
已发货退货量 bigint,
未发货退货量 bi
> 时间: 0.451s