Re: Re: Question about INSERT OVERWRITE TABLE with dynamic partition

2018-10-25 Thread anci_...@yahoo.com
ate: 2018-10-25 08:34 To: user Subject: Re: Question about INSERT OVERWRITE TABLE with dynamic partition 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 res

Re: Question about INSERT OVERWRITE TABLE with dynamic partition

2018-10-24 Thread Tanvi Thacker
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

Question about INSERT OVERWRITE TABLE with dynamic partition

2018-10-23 Thread anci_...@yahoo.com
Dears, I found an interesting thing. When inserting a NULL result into a partition which already contained some records, there was a difference in the results between using static partition INSERT and using dynamic partition INSERT. See the example below: Partition '20180101