hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From abhishek <ec.abhis...@gmail.com>
Subject Re: I delete my table in hive,but the file in HDFS not be deleted
Date Wed, 07 Dec 2016 05:49:42 GMT
How did you define your table - external or hive managed ? If it's defined as external then
table and when you drop the table , metadata will be delete but the data will still be in
hdfs. 

Sent from my iPhone

> On Dec 6, 2016, at 6:08 PM, "446463844@qq.com" <446463844@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'?
> 446463844@qq.com

Mime
View raw message