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 {}'
