I would like to explain one point ,first sql is Bi(smartbi) tools auto created,This example has normal typical.
[email protected] From: [email protected] Date: 2017-08-01 18:36 To: dev Subject: Re: Re: query Sql run Error thinks, 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 normal. 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 [email protected] From: Billy Liu Date: 2017-08-01 17:28 To: dev Subject: Re: query Sql run Error please check log first. 2017-08-01 16:08 GMT+08:00 [email protected] <[email protected]>: > 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] >
