Thanks guys! Atleast we can have this rolled up in few upcoming releases! :)
On Fri, Aug 28, 2015 at 8:20 PM, Luke Han <[email protected]> wrote: > 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! > > > > >
