Shulou(Shulou.com)06/02 Report--

Environment Description:

In the rectification hive table, only the basic analysis library jcfxhivedb; has writeable permission, and the corresponding hdfs directory is: /warehouse/yhgzjchx/

hive table:imsi_tmp

The corresponding data file in the hdfs directory

`hadoop fs -rmr /warehouse/yhgz_jchx/00`

Data cannot be deleted because Trash does not have permission to write

Solution:

Force deletion of data files in the hdfs directory with the-skilTrash option

[eastcom@vq37dsjf01 ~]$ hadoop fs -rm -r -skipTrash /warehouse/yhgz_jchx/00*

Deleted /warehouse/yhgz_jchx/000000_0

Hive table deletion:

beeline

drop table imsi_tmp;

Unable to delete, you can delete the relevant data files in hdfs through the above command, and then connect to hive library in beeline to delete the table.

drop table imsi_tmp;

The table has been deleted

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.