A logical explanation could be:-
In the first query, you are telling hive which partition to overwrite, so a
step which actually deletes the partition data and overwrites it with the
query result, knows that which partition to delete and there is an empty
result/file to move.
but for the second qu
I'm not sure but when you need to make a remote connection, you may try
using the filesystem confs(hdfs-site.xml and core-site.xml) of remote
DFS(hadoop-1xx:9000) in the classpath of hive client of
cluster(ds-1xx)(remember to exclude the local hdfs-site.xml and
core-site.xml)
Regards
Tanvi Thacke
