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

Posted to dev@kylin.apache.org by wanghaifei <wa...@jd.com> on 2015/03/31 11:55:03 UTC

about Foreign key of lookup table

   hi,
      Here has a example:
               select  province_name, count(user_id) from dw.fact_1 as a 
               right  join  dim.dim1  as b on    b.province_id=a.rev_addr_province_id
               group by province_name
               
      I choose  province_id, rev_addr_province_id, province_name  as Dimension. But  when I  save the cube it  has a error.The error content:
              Error Message

         Cannot find rowkey column PROVINCE_ID in cube
   
    question :
               If I remove   province_id from Dimension, the cube builded successed. But  how to join dim1 , to realize that  example?

Re: about Foreign key of lookup table

Posted by Li Yang <li...@apache.org>.

This bug is fixed in staging and master branch.

On Fri, Apr 3, 2015 at 1:28 PM, jason zhong <he...@gmail.com> wrote:

> thanks for report this issue.
>
> Jira ticket also created for the '*Cannot find rowkey*' issue
>
> https://issues.apache.org/jira/browse/KYLIN-658
>
> On Tue, Mar 31, 2015 at 5:55 PM, wanghaifei <wa...@jd.com> wrote:
>
> >    hi,
> >       Here has a example:
> >                select  province_name, count(user_id) from dw.fact_1 as a
> >                right  join  dim.dim1  as b on
> > b.province_id=a.rev_addr_province_id
> >                group by province_name
> >
> >       I choose  province_id, rev_addr_province_id, province_name  as
> > Dimension. But  when I  save the cube it  has a error.The error content:
> >               Error Message
> >
> >          Cannot find rowkey column PROVINCE_ID in cube
> >
> >     question :
> >                If I remove   province_id from Dimension, the cube builded
> > successed. But  how to join dim1 , to realize that  example?
> >
>

Re: about Foreign key of lookup table

Posted by jason zhong <he...@gmail.com>.

thanks for report this issue.

Jira ticket also created for the '*Cannot find rowkey*' issue

https://issues.apache.org/jira/browse/KYLIN-658

On Tue, Mar 31, 2015 at 5:55 PM, wanghaifei <wa...@jd.com> wrote:

>    hi,
>       Here has a example:
>                select  province_name, count(user_id) from dw.fact_1 as a
>                right  join  dim.dim1  as b on
> b.province_id=a.rev_addr_province_id
>                group by province_name
>
>       I choose  province_id, rev_addr_province_id, province_name  as
> Dimension. But  when I  save the cube it  has a error.The error content:
>               Error Message
>
>          Cannot find rowkey column PROVINCE_ID in cube
>
>     question :
>                If I remove   province_id from Dimension, the cube builded
> successed. But  how to join dim1 , to realize that  example?
>

Re: about Foreign key of lookup table

Posted by "Shi, Shaofeng" <sh...@ebay.com>.

You don¹t need put all province_id, rev_addr_province_id, province_name
into dimensions; Leave just the one that you¹re going to group by, which
is ³province_name² in this case.
 


On 3/31/15, 5:55 PM, "wanghaifei" <wa...@jd.com> wrote:

>   hi,
>      Here has a example:
>               select  province_name, count(user_id) from dw.fact_1 as a
>               right  join  dim.dim1  as b on
>b.province_id=a.rev_addr_province_id
>               group by province_name
>               
>      I choose  province_id, rev_addr_province_id, province_name  as
>Dimension. But  when I  save the cube it  has a error.The error content:
>              Error Message
>
>         Cannot find rowkey column PROVINCE_ID in cube
>   
>    question :
>               If I remove   province_id from Dimension, the cube builded
>successed. But  how to join dim1 , to realize that  example?
>