Hi,
这个问题目前没有太好的解决办法,kylin不支持Online Schema Change。不过可以通过一些其他方式提高你的效率,可以参考我的做法哈:
1.使用hive中的视图(view),这样可以避免一部分表结构变更引起的问题(比如字段名修改之类的,只需改一下视图即可)。但是增加维度列无法避免。
2.使用rest api构建model/cube,可以批量操作。这样比在页面上点击构建效率要高太多了。
















在 2020-06-08 09:21:44,"梅秋莹" <[email protected]> 写道:

Hello everyone,


       Who can help me? Expecting for your reply!




------------------ 原始邮件 ------------------
发件人: "梅秋莹"<[email protected]>;
发送时间: 2020年6月4日(星期四) 下午5:46
收件人: "user"<[email protected]>;
主题: If the source table structure changed in Hive, How should I cope with the 
model and cube which have been created for a time?


Hi! Dear kyliners:
   
       There is a question confused me for a long time. In some situations, we 
would change the table structure in  Hive. For those tables which were loaded


from Hive, we have used it to create the model and build cube in kylin. But if 
the Hive source table structures have been changed, it would reduce the cube


even the model to be ineffective.


       What I want to  know is there any better and more sophisticated 
solutions other than delete the cube or delete the model. Because it costs me 
too much


time on creating model and cube.


ps:My kylin env is 2.6.3 and Hive env is 3.1.0.

Reply via email to