We will drop the intermediate hive table in the end (when reach 1.0?). Right now, it is kept for troubleshooting purpose.
On Thu, Apr 2, 2015 at 3:03 PM, Shi, Shaofeng <[email protected]> wrote: > 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 {}' > >> > >> > >> > >
