kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Luke Han <luke...@gmail.com>
Subject Re: Qury about Measures Formula
Date Mon, 02 Mar 2015 12:47:01 GMT
subquery should fulfill this case. please have a try and let's know if
there's any issue.

And, if this is just indicate, can you process it in ETL phase when create
Hive table?

Thanks.

Luke



Best Regards!
---------------------

Luke Han

2015-03-02 20:16 GMT+08:00 Santoshakhilesh <santosh.akhilesh@huawei.com>:

> Hi All ,
>
>
>
>     While adding measures while making cube. The formulas supported are
> count , max , min , ...
>
>
>
>     I have a case where the measure is simply not a count , max , min or
> sum
>
>
>
>     I want to define based on the value of a column in fact table like
> below.
>
>
>
>     count(case when column1 < 5 or column2 < 5 or column3 < 80 or column <
> 15 then  1 else 0 end)
>
>
>
>     How do I support such measures using kylin ? Is there a way to do this
> ?
>
>
>
> Regards,
> Santosh Akhilesh
> Bangalore R&D
> HUAWEI TECHNOLOGIES CO.,LTD.
>
> www.huawei.com
>
> -------------------------------------------------------------------------------------------------------------------------------------
> This e-mail and its attachments contain confidential information from
> HUAWEI, which
> is intended only for the person or entity whose address is listed above.
> Any use of the
> information contained herein in any way (including, but not limited to,
> total or partial
> disclosure, reproduction, or dissemination) by persons other than the
> intended
> recipient(s) is prohibited. If you receive this e-mail in error, please
> notify the sender by
> phone or email immediately and delete it!
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message