insert on condition

Hello All, Is it possible to achieve " Insert overwrite into a partition only if it does not exist " ? Partition is a string date. Thanks, Anup

Re: Anyway to avoid creating subdirectories by "Insert with union²

HI Gopal, Another question which i have is whenever we run Union All statement, apart from Folders we also see Zero Bytes Files in HDFS. Are there locks file (LCK) ? Mahender On 2/24/2016 4:26 PM, Gopal Vijayaraghavan wrote: >> SET mapred.input.dir.recursive=TRUE; > ... >> Can we set above set

Zero Bytes Files importance

Hi When we dump or have hive query to insert data into another hive table. There will be Folder which contains actual data and apart from that we see another 0 Byte File present at same level. I would like to understand importance of Zero byte files. What happens if we delete this file. [ci

Zero Bytes Files importance

Hi When we dump or have hive query to insert data into another hive table. There will be Folder which contains actual data and apart from that we see another 0 Byte File present at same level. I would like to understand importance of Zero byte files. What happens if we delete this file. Plea