doris版本:doris-1.2.6-rc03
第一条sql:
select
d1 as gc,
bitmap_count(bitmap_union(to_bitmap(e.did))) as mc
from
sensors_events_dma as e lateral view explode_outer(split_by_string(brand_name_s, '_$_')) t2 as d1
where
event = 'OrderPayForBuyer'
and event_time >= '2023-09-16 00:00:00'
and event_time <= '2024-07-12 15:46:54'
group by
1
第二条sql:
select
*
from
(
select
d1 as gc,
bitmap_count(bitmap_union(to_bitmap(e.did))) as mc
from
sensors_events_dma as e lateral view explode_outer(split_by_string(brand_name_s, '_$_')) t2 as d1
where
event = 'OrderPayForBuyer'
and event_time >= '2023-09-16 00:00:00'
and event_time <= '2024-07-12 15:46:54'
group by
1) as tt
where
gc = '索菲亚'
执行第一个sql,没问题,查询结果为,但是执行第二个sql报错,报错信息:Unexpected exception: Predicate:
d1
= '索菲亚' can't be assigned to some PlanNode.
第二个SQL就是在第一个SQL外面加了一层,麻烦看看是什么问题