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

Posted to user@kylin.apache.org by you Zhuang <zh...@gmail.com> on 2018/09/19 06:32:42 UTC

is there a way to achieve factTable A inner join LookupTable B on concat(A.f1,A.f2) = B.f1 ?

In kylin,is there a way to achieve factTable A inner join LookupTable B on concat(A.f1,A.f2) = B.f1 ?

Re: is there a way to achieve factTable A inner join LookupTable B on concat(A.f1,A.f2) = B.f1 ?

Posted by ShaoFeng Shi <sh...@apache.org>.

Try to use a hive view to concat the columns to a new column, and then use
the view and the new column in the cube.

you Zhuang <zh...@gmail.com> 于2018年9月19日周三 下午2:32写道：

> In kylin,is there a way to achieve factTable A inner join LookupTable B on
> concat(A.f1,A.f2) = B.f1 ?



-- 
Best regards,

Shaofeng Shi 史少锋