kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <>
Subject Re: Question: how to reload looup table from hive
Date Wed, 27 Dec 2017 14:07:29 GMT
Hi Jxs,

You're right;  "Reload table" only sync the table metadata/definition, no
other changes.

To refresh the lookup table data in Kylin, you need to rebuild the cube.
You can select one or multiple segments to rebuild, depends on which part
of history data expect to reload the new lookup.

2017-12-26 13:56 GMT+08:00 jxs <>:

> Hi,
> I have a cube left joining another lookup table, I encountered a problem
> with reloading the lookup table.
> The Problem:
>   After the cube has been built, I found that the lookup table has some
> trailing space characters in a foreign key field which prevent the two
> tables being joined.
>   So I updated the lookup table with correct data without trailing space
> characters.
>   But from kylin, I always get the old data with trailing spaces.
>   I have tried "Reload Metadata", "Reload Table", they did not help.
> Am I missing something ? Or this work can't be done without rebuilding the
> whole cube?
> Any help is appreciated, thanks.

Best regards,

Shaofeng Shi 史少锋

View raw message