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, 沙漠火狐 <[email protected]> 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.
