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