Get it, thank you, Shaofeng.
发自网易邮箱大师 On 12/27/2017 22:07, ShaoFeng Shi wrote: 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 <[email protected]>: 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 史少锋
