hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aleksei Udatšnõi <a.udac...@gmail.com>
Subject INSERT OVERWRITE with empty data
Date Fri, 29 Jun 2012 08:49:16 GMT
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?

Mime
View raw message