[HIVE-1442] HOLD_DDLTIME does not change partition metadata

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 0.7.0
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: Namit Jain
• Created: 28/Jun/10 00:58
• Updated: 23/Oct/15 16:29
• Resolved: 23/Oct/15 16:29

Description

create table T1 (key string, value string) partitioned by(ds string) stored as sequencefile;

desc extended T1;

insert overwrite table T1 partition (ds='1') select key, value from src;
insert overwrite table T1 partition (ds='2') select key, value from src;

desc extended T1 partition (ds='1');
desc extended T1 partition (ds='2');

alter table T1 set fileformat rcfile;

insert overwrite table T1 partition (ds='1')
select /+ HOLD_DDLTIME/ key, value from src;

insert overwrite table T1 partition (ds='2')
select key, value from src;

desc extended T1 partition (ds='1');
desc extended T1 partition (ds='2');

drop table T1;

T1/ds=1 is left as sequencefile and corrupted after the insert as HOLD_DDLTIME

Issue Links

• relates to: HIVE-1394 do not update transient_lastDdlTime if the partition is modified by a housekeeping operation