Hi Bhanu, Kylin does have a speical optimization for "inner": if a dimension column is the FK on fact table, and the join type is "inner", it will defer the dictionary build to lookup table's PK; Now we see the support for View as lookup didn't cover this case. I will create a JIRA for this when the system is back to live.
Thanks for the reporting! 2016-06-16 5:16 GMT+08:00 Bhanu Mohanty <[email protected]>: > Getting error at Build Dimension Dictionary > java.io.IOException: > NoSuchObjectException(message:DEFAULT.kylin_intermediate_DEFAULT_**** > > On Wed, Jun 15, 2016 at 2:14 PM, Bhanu Mohanty <[email protected]> > wrote: > >> I am using kylin-1.5.2.1 >> >> Added hive view as a look up table >> >> Getting error at Build Dimension Dictionary >> DEFAULT.kylin_intermediate_DEFAULT_* >> >> If the join is "inner" >> It works when I changed the join to "left" >> > > -- Best regards, Shaofeng Shi
