It seems right to me that an existing partition should be overwritten if that partition gets any data while older, untouched partition should stay. After all, we are overwriting certain partitions, not the whole table.
--Xuefu On Mon, Oct 17, 2016 at 6:10 PM, Sergey Shelukhin <ser...@hortonworks.com> wrote: > What do you think this SHOULD do? > > > select key from src; > 10 > 25 > 50 > > > create table t(val int) partitioned by (pk int); > > insert overwrite table t partition (pk) > select 0 as val, key from src where key < 30; > > insert overwrite table t partition (pk) > select 1 as val, key from src where key > 20; > > > > select val, pk from t; > ? > >
