You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Ashika Umanga Umagiliya <um...@gmail.com> on 2016/09/26 06:05:10 UTC
AVG measure is missing?
I cannot find average (ABG) measure in the UI as well as in the
documentation:
In the documentation I cannot find average as well :
"There are 5 different types of measure according to its expression: SUM,
MAX, MIN, COUNT and COUNT_DISTINCT. Please be carefully to choose the
return type, which is related to the error rate of the COUNT(DISTINCT)"
I use the latest 1.5.x version of Kylin
Re: AVG measure is missing?
Posted by ShaoFeng Shi <sh...@apache.org>.
No need to additionally define AVG; SUM is enough.
Re: AVG measure is missing?
Posted by Ashika Umanga Umagiliya <um...@gmail.com>.
thanks for the reply.
I was asking how to use AVG in measures when we create the cube, not during
querying the cubes.
Basically ,
*Step 3. Measures*
http://kylin.apache.org/docs15/tutorial/create_cube.html
On Mon, Sep 26, 2016 at 5:01 PM, ShaoFeng Shi <sh...@apache.org>
wrote:
> You're right, there is no "avg" measure in GUI. "AVG" will be translated
> to "SUM"/"COUNT" in kylin in the query time, so if you have pre-defined the
> two measure, it will work. Just take a try with the sample cube,
> e.g: select avg(price) from kylin_sales
>
> 2016-09-26 14:05 GMT+08:00 Ashika Umanga Umagiliya <um...@gmail.com>:
>
>>
>> I cannot find average (ABG) measure in the UI as well as in the
>> documentation:
>>
>> In the documentation I cannot find average as well :
>>
>> "There are 5 different types of measure according to its expression: SUM,
>> MAX, MIN, COUNT and COUNT_DISTINCT. Please be carefully to choose the
>> return type, which is related to the error rate of the COUNT(DISTINCT)"
>>
>> I use the latest 1.5.x version of Kylin
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>
--
Umanga
http://jp.linkedin.com/in/umanga
http://umanga.ifreepages.com
Re: AVG measure is missing?
Posted by ShaoFeng Shi <sh...@apache.org>.
You're right, there is no "avg" measure in GUI. "AVG" will be translated to
"SUM"/"COUNT" in kylin in the query time, so if you have pre-defined the
two measure, it will work. Just take a try with the sample cube,
e.g: select avg(price) from kylin_sales
2016-09-26 14:05 GMT+08:00 Ashika Umanga Umagiliya <um...@gmail.com>:
>
> I cannot find average (ABG) measure in the UI as well as in the
> documentation:
>
> In the documentation I cannot find average as well :
>
> "There are 5 different types of measure according to its expression: SUM,
> MAX, MIN, COUNT and COUNT_DISTINCT. Please be carefully to choose the
> return type, which is related to the error rate of the COUNT(DISTINCT)"
>
> I use the latest 1.5.x version of Kylin
>
--
Best regards,
Shaofeng Shi 史少锋