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? apache_...@163.com