You need to have Partition Column in your fact table, which should be 'date' type.
then when create your cube, at step 'Refresh Setting', pick up you partition column and set the start date you want to build. when you build your cube, you will get prompt to input your end date,and next time you build your cube, the end date will be used as start date. so you can get data build incrementally On Tue, Dec 29, 2015 at 1:56 PM, Sudeep Dey <[email protected]> wrote: > Hi All, > > I need a help on using Kylin, where I have a use case where my Hive > data(fact and dimension tables ) are getting populated periodically from > time to time with new data sets. Now how should I approach this use case as > far as Incremental refresh of cubes are concerned. Do I need to have date > column in the fact table to handle the incremental use case? > > > > -- > Thanks and Regards > > Sudeep Dey > Zaloni,Inc. | www.zaloni.com > 633 Davis Drive, Suite 450 > Durham, NC 27713 > e: s <[email protected]>[email protected] > > > "This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity > to which it is addressed. If the reader of this e-mail is not the intended > recipient or his or her authorized agent, the reader is hereby notified > that any dissemination, distribution or copying of this e-mail is > prohibited. If you have received this e-mail in error, please notify the > sender by replying to this message and delete this e-mail immediately." > > > > > > > > > *Visit us at Strata + Hadoop World San Jose - Booth #1335. Not registered > yet? Be sure **to use code ZALONI20 to receive 20% off registration! * > > <http://conferences.oreilly.com/strata/hadoop-big-data-ca?cmp=ba-data-confreg-home-stca16_were_sponsoring>
