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

Reply via email to