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.
