– SQL 如下：
– event_time 为datetime 类型字段
– charging_money 为int 类型字段
– user_id 为string 类型字段
CREATE MATERIALIZED VIEW view_user_charge_test AS
select
user_id ,
array_min(array_agg(event_time)) as first_charge_time,
array_agg(charging_money)[array_position(array_agg(event_time),
array_min(array_agg(event_time)))] as first_charge_money
from
snk_basedata_new
group by
user_id;
– 提示错误如下
– fe.log 中错误如下：
