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 02:14:11 GMT
JIRA created: https://issues.apache.org/jira/browse/KYLIN-1789

2016-06-16 9:52 GMT+08:00 ShaoFeng Shi <shaofengshi@apache.org>:

> 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
>
>


-- 
Best regards,

Shaofeng Shi

Mime
View raw message