You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by "steven zhang (JIRA)" <ji...@apache.org> on 2015/08/27 06:31:45 UTC

[jira] [Created] (KYLIN-970) Support AVG(calculating average value) Function in Kylin

steven zhang created KYLIN-970:
----------------------------------

             Summary: Support AVG(calculating average value) Function in Kylin
                 Key: KYLIN-970
                 URL: https://issues.apache.org/jira/browse/KYLIN-970
             Project: Kylin
          Issue Type: Improvement
    Affects Versions: v0.7.1
            Reporter: steven zhang
            Priority: Minor


on some scenes we want to calculate the average value for statistics
so i think it is necessary to support AVG function 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Re: [jira] [Created] (KYLIN-970) Support AVG(calculating average value) Function in Kylin

Posted by hongbin ma <ma...@apache.org>.

AVG does not need to be defined as a special metric, you just need to
define sum and count for it.

When you query using avg(), it will automatically be translated into
sum/count

On Thu, Aug 27, 2015 at 12:31 PM, steven zhang (JIRA) <ji...@apache.org>
wrote:

> steven zhang created KYLIN-970:
> ----------------------------------
>
>              Summary: Support AVG(calculating average value) Function in
> Kylin
>                  Key: KYLIN-970
>                  URL: https://issues.apache.org/jira/browse/KYLIN-970
>              Project: Kylin
>           Issue Type: Improvement
>     Affects Versions: v0.7.1
>             Reporter: steven zhang
>             Priority: Minor
>
>
> on some scenes we want to calculate the average value for statistics
> so i think it is necessary to support AVG function
>
>
>
> --
> This message was sent by Atlassian JIRA
> (v6.3.4#6332)
>



-- 
Regards,

*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone