When overwrite a table in hive dialect, it might not overwrite but to append.
It can reproduce using the following sql:
only happen when the table is encapsulated by backquote and the table contain two splits with ".".
Just find the behavior in hive is also incorrect as reported in
Let'us keep to see what's the expected behavior.