kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: Support Hive View as Lookup Table
Date Thu, 16 Jun 2016 01:52:34 GMT
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 <bhanu.mohanty@gmail.com>:

> 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 <bhanu.mohanty@gmail.com>
> 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

Mime
View raw message