MM/ACID tables: make tests that will never be compatible with acid use non-txn tables explicitly

Some tests do stuff that will simply never work with ACID tables, e.g. delete table files.
They should be changed to use external table, or explicitly set transactional=false

List of things:

• Deleting table files via dfs commands.
• Computing query using stats - not supported for either ACID tables or external tables, so with MM by default not supported in any scenario. HIVE-18395