You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by bubugao0809 <bu...@163.com> on 2017/09/20 08:42:03 UTC

Global dictionary dose not support for column that serves as both measure and dimension

Hi, all

I found the following content from URL: http://kylin.apache.org/blog/2016/08/01/count-distinct-in-kylin/

"The global dictionay cannot be used for dimension encoding for now, that means if one column is used for both dimension and count distinct measure in one cube, its dimension encoding should be others instead of dict."

It means that the column, serving as both measure and dimension, can also use the 'Global dictionary'.

For my case, I use DIM_DEVELOPER.DEVELOPER_ID for count distinct in measure, as well as the dimensions. And I change the encoding in Rowkeys (listed in the 4th row) from dict to integer with the lenght of 8.

However, it still does not work, showing the following error messge:  'ERROR : Global dictionary couldn't be used for dimension column: DIM_DUI.DIM_DEVELOPER.DEVELOPER_ID'

I was wondering if there is any way that I could work around, because the situation tjhat column serves as both measure and dimension is quite common in productive env






Re: Global dictionary dose not support for column that serves as both measure and dimension

Posted by Li Yang <li...@apache.org>.
This is a known issue. https://issues.apache.org/jira/browse/KYLIN-2679
Thanks for reporting again. This will help the priority of the task.

On Wed, Sep 20, 2017 at 4:42 PM, bubugao0809 <bu...@163.com> wrote:

> Hi, all
>
> I found the following content from URL: http://kylin.apache.org/blog/
> 2016/08/01/count-distinct-in-kylin/
>
> "The global dictionay cannot be used for dimension encoding for now, that
> means if one column is used for both dimension and count distinct measure
> in one cube, its dimension encoding should be others instead of dict."
>
> It means that the column, serving as both measure and dimension, can also
> use the 'Global dictionary'.
>
> For my case, I use DIM_DEVELOPER.DEVELOPER_ID for count distinct in
> measure, as well as the dimensions. And I change the encoding in Rowkeys
> (listed in the 4th row) from dict to integer with the lenght of 8.
>
> However, it still does not work, showing the following error messge:  'ERROR
> : Global dictionary couldn't be used for dimension column:
> DIM_DUI.DIM_DEVELOPER.DEVELOPER_ID'
>
> I was wondering if there is any way that I could work around, because the
> situation tjhat column serves as both measure and dimension is quite common
> in productive env
>
>
>
>