Re: what's the "pre-computing" actually meaning in Kylin?

["liubo@fcyun.com" <li...@fcyun.com>]

Hi all,
    The greate feature of  Kylin is "pre-computing",  but I don't know how to use it correctly.

In my recent situation, my pre-compute business logic is, to determine a store's validation by its deal numbers per day.
1.if the store have more than three deals and every deal money more than 5.00, this store is valid in the day.
or
2.if the store have a deal and its money more than 500.00, then it's valid.

My question is, how  and where to place these compute logic? 
I want it should be pre-computed,but I have no ideal how to do it.

In my opinion, it cannot present the compute logic in cube creation.
And, I don't know how to present the compute login in SQL correctly.


Or Kylin just can comput on the already data in the columns?
The business-logic compute cannot present in the Kylin pre-computing function?








liubo@fcyun.com

Re: what's the "pre-computing" actually meaning in Kylin?

[ShaoFeng Shi <sh...@apache.org>]

You're welcome.

2017-11-01 10:00 GMT+08:00 liubo@fcyun.com <li...@fcyun.com>:

> Thanks ShaoFeng Shi, I will use the Hive view to pre-compute some business
> balues.
> Hive's ETL function can be a good tool for some computing before load data
> into Kylin cube.
>
> ------------------------------
> liubo@fcyun.com
>
>
> *From:* liubo@fcyun.com
> *Date:* 2017-10-31 12:31
> *To:* user <us...@kylin.apache.org>
> *Subject:* what's the "pre-computing" actually meaning in Kylin?
>
>
>
> Hi all,
>     The greate feature of  Kylin is "pre-computing",  but I don't know how
> to use it correctly.
>
> In my recent situation, my pre-compute business logic is, to determine a
> store's validation by its deal numbers per day.
> 1.if the store have more than three deals and every deal money more than
> 5.00, this store is valid in the day.
> or
> 2.if the store have a deal and its money more than 500.00, then it's valid.
>
> My question is, how  and where to place these compute logic?
> I want it should be pre-computed,but I have no ideal how to do it.
>
> In my opinion, it cannot present the compute logic in cube creation.
> And, I don't know how to present the compute login in SQL correctly.
>
>
> Or Kylin just can comput on the already data in the columns?
> The business-logic compute cannot present in the Kylin pre-computing
> function?
>
>
>
>
>
>
> ------------------------------
> liubo@fcyun.com
>
>


-- 
Best regards,

Shaofeng Shi 史少锋