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' of table A contained 100 records.
By using
we can delete the records in partition '20180101'.
But by using
there would be no change to the partition '20180101'.
In fact, if we running 'select * from A where partition_A = '20180101''
, we will still get 100 records from it.
Expecting an explanation for it.
Thanks!
孙志禹
