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;
?

Reply via email to