Hi Vineet,
Currently, custom measure is not supported yet.
But by design, yes, it will be support, that's why I put "Expression"
not "Function" there;-)
This is actually a common requirements, Dayue's company also has same
use case, the question is:
how complicate expression should to be supported? and then how about UDF?
Dayue and I have discussed this last week when I'm in Beijing. He may
have more comments later.
I have created KYLIN-976
<https://issues.apache.org/jira/browse/KYLIN-976> for tracking.
Please leave your idea and discussion there.
Thanks.
Best Regards!
---------------------
Luke Han
On Fri, Aug 28, 2015 at 10:01 PM, Shi, Shaofeng <[email protected]> wrote:
> Kylin doesn¹t support custom function in measure; Usually we suggest user
> to achieve this by defining additional column in a hive view, and then use
> the view as the fact table for cube building; That will make things easy;
> In eBay internal there are already several cases using this way;
>
> On 8/28/15, 7:12 PM, "Vineet Mishra" <[email protected]> wrote:
>
> >Hi All,
> >
> >I was curious to know whether can we create some additional metric(custom)
> >to the Kylin cube build.
> >
> >So it would be something like an additional column which is made from
> >combination of some conditional and aggregate function.
> >
> >COUNT(CASE WHEN so.ft = 'fv' THEN soi.sc ELSE NULL END) AS spo
> >
> >Thanks!
>
>
