hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Shelukhin <ser...@hortonworks.com>
Subject behavior or insert overwrite with dynamic partitions
Date Tue, 18 Oct 2016 01:10:01 GMT
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;
?

Mime
View raw message