kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JiaTao Tao <taojia...@gmail.com>
Subject Re: Duplicate data in kylin cube while rebuilding at regular intervals.
Date Tue, 05 Feb 2019 15:27:11 GMT
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 <prasanna.p@trinitymobility.com> 于2019年2月5日周二 下午12:51写道:

>
>
> Please help here  to solve this issue.
>
> *Thanks & Regards,*
>
> *Prasanna.P,*
>
> *Trinity Mobility Pvt. Ltd. | Bangalore.*
>
> *[image: cid:image005.png@01D48186.3F73A010]*
>
>
>
> *From:* Prasanna [mailto:prasanna.p@trinitymobility.com]
> *Sent:* 05 February 2019 16:58
> *To:* 'user@kylin.apache.org'
> *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
>
>
>

Mime
View raw message