Re: Fact table have three field relate Lookuo table, how to create Models

[Li Yang <li...@apache.org>]

This is a known issue: https://issues.apache.org/jira/browse/KYLIN-995

Work around is duplicate B 3 times. For example, creating 3 external tables
from the same data folder.


Yang


On Fri, Jul 8, 2016 at 8:44 PM, 沙漠火狐 <27...@qq.com> wrote:

> Hi ~
>        I want to kown how to create Kylin Models in this situation :
>        table A is a fact table with five fields of  a_id, b1,b2,b3,
> a_value,
>        table B is a lookup table has two fields of b_id,  b_name.
>        b1, b2,b3 in table A is come from b_id in table B.
>
>        in usual,  I will write a SQL use alias  like that:
>        select b1,B1.b_name,   b2,B2.b_name,    b3, B3_b_name
>        from A left join B B1 on A.b1 = B1.b_id
>                  left join B B2 on  A.b2 = B2.b_id
>                  left join B B3 on  A.b3 = B3.b_id
>
>
>       in kylin there are no alias to add lookup table, I add three times
> use the same lookup table, but only the first is valid.
>
>
>       I don't kown how to make a star schema in kylin for this case.