Hi Kylin will build cubes with current data and do not support update cube data in record level. I'm afraid that you need to rebuild your cube in that case. We usually don't update record directly in Hadoop, especially the fact table.
-- Regards! Aron Tao Prasanna <[email protected]> 于2019年2月5日周二 下午12:51写道： > > > Please help here to solve this issue. > > *Thanks & Regards,* > > *Prasanna.P,* > > *Trinity Mobility Pvt. Ltd. | Bangalore.* > > *[image: cid:[email protected]]* > > > > *From:* Prasanna [mailto:[email protected]] > *Sent:* 05 February 2019 16:58 > *To:* '[email protected]' > *Subject:* Duplicate data in kylin cube while rebuilding at regular > intervals. > > > > Dear team, > > > > I am using kylin 2.2.0 version. In my use case I have a transactional > table and data is updating on daily basis(insert+update) without duplicates > (data will override) .if I am importing table data into kylin cubes with > regular intervals ,I am getting duplicate copies of data with different > timestamps. How to handle this case? How to override existed data in cube > with updated data?. > > Sample: > > > > select * from table_name where table_name.CALLID ='103399' > > > > result: > > > > > > > > Regards, > > Prasanna.P > > >
