I have a Hive query like: INSERT OVERWRITE TABLE a SELECT * FROM b WHERE ..;
Table A is not partitioned, table B is. If the SELECT from B contains some data, it is replaced in table A as expected. However if the result of the SELECT is empty, the data in table A does not get truncated. The original data stays in the table. The issue depends on the environment. In one cluster it works (table gets truncated), in another it doesn't. Any idea what may be causing such behavior? Perhaps some global Hive settings or privileges?
