Is the table external or managed? External tables do not remove their data when dropped, managed tables do.
Alan. > On Dec 6, 2016, at 18:08, 446463...@qq.com wrote: > > I meet a problem in hive. > > I drop a table in hive and the table name ' user_info_20161206' > --------------------------------------- > hive> show tables; > OK > kylin_cal_dt > kylin_category_groupings > kylin_intermediate_dmp_cube_fb5904cf_a4d3_4815_802d_c31afe9119e9 > kylin_intermediate_test_cube_08677652_0f84_4322_a2a5_0a963723579e > kylin_intermediate_test_cube_a37beebf_d7da_4956_8e25_d563dd834364 > kylin_intermediate_test_cube_aa9ee162_0d45_4ea6_853d_6df127799edf > kylin_sales > Time taken: 0.045 seconds, Fetched: 7 row(s) > hive> > -------------------------------------- > but I find the user_info_20161206 file is exist in HDFS file > ------------------------------------------------ > drwxrwxrwt - hadoop hadoop 0 2016-09-26 11:50 > /user/hive/warehouse/dm.db > drwxrwxrwt - hadoop hadoop 0 2016-11-21 15:39 > /user/hive/warehouse/dw.db > drwxrwxrwt - hadoop hadoop 0 2016-11-03 12:44 > /user/hive/warehouse/kylin_cal_dt > drwxrwxrwt - hadoop hadoop 0 2016-11-03 12:44 > /user/hive/warehouse/kylin_category_groupings > drwxrwxrwt - hadoop hadoop 0 2016-11-03 12:44 > /user/hive/warehouse/kylin_sales > drwxrwxrwt - hadoop hadoop 0 2016-09-26 11:50 > /user/hive/warehouse/ods.db > drwxrwxrwt - hadoop hadoop 0 2016-11-30 17:53 > /user/hive/warehouse/raw.db > drwxrwxrwt - hadoop hadoop 0 2016-09-26 11:50 > /user/hive/warehouse/rpt.db > drwxrwxrwt - hadoop hadoop 0 2016-09-26 11:50 > /user/hive/warehouse/temp.db > drwxrwxrwt - hadoop hadoop 0 2016-11-24 13:17 > /user/hive/warehouse/test.db > drwxrwxrwt - hive hadoop 0 2016-12-06 21:15 > /user/hive/warehouse/user_info_20161206 > -------------------------------------------------- > I don't kown why I drop table in hive but the same file not delete in HDFS . > I test in mine test environment,it's work > the owner of file is 'hive' not 'hadoop'? > 446463...@qq.com
