Hi,
Kylin2.0 on HDP2.5.3.
sql is not work.
select T7.F16 as F3,SUM(T7.F0) as F4
from (
select T17.QTR_ID as F16,T8.I_eceb82a4498247aeb911ba59f82148f0 as F0
from KYLIN_CAL_DT T17
inner join
(
select KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID, sum(KYLIN_SALES.PRICE)
I_eceb82a4498247aeb911ba59f82148f0
from KYLIN_SALES where PART_DT in('2012-01-01', '2012-01-02', '2012-01-03')
group by KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID
) T8
on T8.PART_DT = T17.CAL_DT
) T7
group by T7.F16
but this sql can work
select T7.F16 as F3,SUM(T7.F0) as F4 from
(
select F16,F0 from
(
select T17.QTR_ID as F16,T8.I_eceb82a4498247aeb911ba59f82148f0 as F0
from KYLIN_CAL_DT T17
inner join
(
select KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID, sum(KYLIN_SALES.PRICE)
I_eceb82a4498247aeb911ba59f82148f0
from KYLIN_SALES where PART_DT in('2012-01-01', '2012-01-02', '2012-01-03')
group by KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID
) T8
on T8.PART_DT = T17.CAL_DT
) T7
group by F16,F0
) T7
group by T7.F16
What's the reason?
[email protected]
