Hi Alberto, when I was saying 6 vs 365 its for one item. for 20 Million items it will multiply by a lot. Do you think it wont make much differnce? Also what is YY-MM-WW ? so I can explain you? Basically I need same avg() for week, month, year, etc.
Thanks Deva On Thu, Mar 1, 2018 at 8:42 AM, Alberto Ramón <[email protected]> wrote: > - the 95% of time response, are latencies (= there is no difference > between sum one int or 365, I thought the same when I started with Kylin) > - The YY-MM-WW, is not implemented, but can be nice if you can contribute > to it > > Alb > > On 28 February 2018 at 22:59, deva namaste <[email protected]> wrote: > >> I was thinking of saving only 6 records in kylin instead of splitting >> them outside in daily avg and adding 365 records for each item. So is >> there anyway I can achieve using sql level in kylin or have changes to >> model to accomodate above change? Please advice. Thanks >> >> On Wed, Feb 28, 2018 at 5:51 PM, Alberto Ramón <[email protected] >> > wrote: >> >>> Sounds like: >>> - your minimum granularity for queries are on Weeks, your fact table >>> need be on weeks (or less, like days) >>> - you will need expand you actual fact table to weeks (or more, days) >>> Example use a hive view >>> - as extra: Kylin can't use partition format columns on weeks, the >>> minimum es days >>> >>> Alb >>> >>> On 28 February 2018 at 21:51, deva namaste <[email protected]> wrote: >>> >>>> Hello, >>>> >>>> How would I calculate value for a week while I have bi-monthly values. >>>> >>>> e.g. Here is my data looks like - >>>> >>>> Date - Value >>>> 01/18/2017 - 100 >>>> 03/27/2017 - 130 (68 Days) >>>> 05/17/2017 - 102 (51 Days) >>>> >>>> I need average value per week, as below. Lets consider between 03/27 >>>> and 05/17. So total days between period are 51. so Daily average would be >>>> 102/51= 2.04 >>>> >>>> Week4 (Starting March 26, #days = 4) = (4 x 2.04) = 8.16 >>>> Week1 (Starting Apr 2, #days = 7) = 14.28 >>>> Week2 (starting Apr 9, #days = 7)= 14.28 >>>> Week3 (starting Apr 16, #days = 7)= 14.28 >>>> Week4 (starting Apr 23, #days = 7)= 14.28 >>>> week5 (Starting Apr 30, #days =7)= 14.28 >>>> week1 (starting May 7, #days = 7)= 14.28 >>>> Week2 (starting May 14, #days = 4)= 8.16 >>>> >>>> But as you see that period from 01/18 to 03/27, have 68 days and daily >>>> average would be 130/68=1.91 >>>> >>>> So really to get complete week I need 3 days from 130 value and 4 days >>>> from 102 value. >>>> >>>> So real total for that first week would be - >>>> Week4 (Starting March 26, #days = 4) = (4x2.04=8.16) + (3x1.91=5.73) = >>>> 13.89 >>>> >>>> How would I achieve this in Kylin? Any function? or other method I can >>>> use? >>>> Just for 6 records for year, I dont want to populate daily records. >>>> Thanks >>>> Deva >>>> >>>> >>>> >>> >> >
