Description
Previously there's a validation check for sql, since dynamic column does not support sum(col1/col2). However, if the sql has a subquery and sum(col1/col2) is in the main query rather than the sub-query, this should be OK. One example is as follows:
select T1.D1, sum(T1.gmv/T2.gmv)
from
(select D1, D2, sum(M1) as gmv
from T
group by D1, D2) T1
inner join
(select D1, D2, sum(M2) as gmv
from T
group by D1, D2) T2
on T1.D1 = T2.D1
group by T1.D1
Since the outside sum(T1.gmv/T2.gmv) is handled by calcite rather than Kylin, it's OK and should not go through the verification.
Attachments
Attachments
Issue Links
- relates to
-
KYLIN-3358 Support sum(case when...), sum(2*price+1), count(column) and more
- Closed