创建视图报错 ERROR 1064 (HY000): Unexpected exception: failed to init view stmt

【详述】创建视图报错 ERROR 1064 (HY000): Unexpected exception: failed to init view stmt
【业务影响】
【StarRocks版本】例如:2.5.4
【附件】

  • 建表DDL 建表DDL.txt (1.2 KB)
    创建视图语句 : create view bdc_df.err_100024_property_test as
    select t2.key as attr_name from
    bdc_dwd.err_info_100024_real_time, JSON_EACH(key_word) as t2

最开始报错的创建视图语句 : create view bdc_df.err_100024_property_test as
select t2.key as attr_name, log_type, #event_name, data,platform,dt,#process_time
from (select get_json_string(key_word, ‘$.6’) as col_arr, #event_name, log_type, data,platform,dt,#process_time
from bdc_dwd.err_info_100024_real_time
where dt >=‘2023-08-30’ and JSON_EXISTS(key_word, ‘$.6’))t, LATERAL JSON_EACH(col_arr) as t2

具体创建的语句麻烦提供下 然后集群版本是2.5.4版本吗?