Merge cube segments will base on the generated cuboid files, not the intermediate hive table, so it is safe to drop the hive table once the base cuboid be calculated;
On 4/2/15, 2:58 PM, "dong wang" <[email protected]> wrote: >for this, I have a question that after building the cube segment >successfully, whether the intermediate tables are useful or not when >MERGING some segments? > >2015-04-02 14:26 GMT+08:00 Shi, Shaofeng <[email protected]>: > >> Kylin creates an intermediate flat table when building a cube each time; >> Due to some reason the table wasn¹t dropped automatically after cube be >> built; So after some period of time, we suggest you to drop these >>tables to >> cleanup the HDFS space; Here is a simple command to drop all these temp >> tables in batch (make sure there is no cube being built): >> >> hive -e 'show tables' | grep kylin_intermediate_ | xargs -I '{}' hive -e >> 'drop table {}' >> >> >>
