ql/src/test/queries/clientpositive/partition_decode_name.q

--! qt:dataset:src
create table sc_n0 as select * 
from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows)
      union all 
      select '2011-01-11', '2011-01-11+15:18:26' from src tablesample (1 rows)
      union all 
      select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s;

create table sc_part_n0 (key string) partitioned by (ts string) stored as rcfile;

set hive.exec.dynamic.partition=true;

set hive.decode.partition.name=false;
insert overwrite table sc_part_n0 partition(ts) select * from sc_n0;
show partitions sc_part_n0;
select count(*) from sc_part_n0 where ts is not null;

set hive.decode.partition.name=true;
insert overwrite table sc_part_n0 partition(ts) select * from sc_n0;
show partitions sc_part_n0;
select count(*) from sc_part_n0 where ts is not null;