Why Does Metadata Still Exist When the HDFS Data Directory of the Hive Table Is Deleted by Mistake?

Question

The HDFS data directory of the Hive table is deleted by mistake, but the metadata still exists. As a result, an error is reported during task execution.

Answer

This is an exception caused by misoperation. You need to manually delete the metadata of the corresponding table and try again.

Example:

Run the following command to log in to the Hive metabase:

source ${BIGDATA_HOME}/FusionInsight_BASE_xxx/install/FusionInsight-dbservice-2.7.0/.dbservice_profile

gsql -p 20051 -U hive -d hivemeta -W Password for the database user hivemeta

Manually delete the metadata of the corresponding table:

delete from tbls where tbl_id='xxx';