I don't think kylin can use expression in join, in our experience, we always create view based on hive table when we meet the problem of source metadata or data and it always works. for example, you can create a view with remove issues datas and use the view as lookup table.
hopefully it will be useful to you.. 2015-11-20 16:18 GMT+08:00 Roy <[email protected]>: > Hi All, > > when i was use kylin add lookup tables,i can add condition to > tb1.field1=tb2.field2,but if i want field1=expression(like and field2='0') > ,need necessary write expression to cube filter? > > in look table exitst some issues data, i need remove first.but i don't > want to create the new tmp table, we konw in SQL left join sentence are > before the where sentnece. any idea for this issues? > > Best Regards > > > > > >
