Javadoc
Handles dropDatabase by invoking drop_table in HMS for each table.
Useful when table list in DB is too large to fit in memory. It will retrieve tables in
chunks and for each table with a drop_table hook it will invoke drop_table on both HMS and
the hook. This is a timely operation so hookless tables are skipped and will be dropped on
server side when the client invokes drop_database.
Note that this is 'less transactional' than dropDatabaseCascadePerDb since we're dropping
table level objects, so the overall outcome of this method might result in a halfly dropped DB.