[Bug] When using the Hive catalog, after deleting the table directory, it is no longer possible to drop the table

### Minimal reproduce step

1. using hive catalog
2. create table
3. delete table in file system
4. drop table (it is no longer possible to drop the table in hms)

This is because the DROP TABLE command checks whether the table exists fisrtly, and we determine the table's existence based on whether it exists in the filesystem.

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

Start by reproducing the Hive catalog sequence: create a table, delete its filesystem directory, then run DROP TABLE. Trace the DROP TABLE existence check and compare filesystem presence with the Hive metastore entry; done means a table whose directory was deleted can still be dropped from HMS, with regression coverage for this sequence.

Written by the indexing model from the issue text.