[HIVE-1318] External Tables: Selecting a partition that does not exist produces errors

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 0.5.0
• Assignee: Unassigned
• Reporter: Edward Capriolo
• Created: 22/Apr/10 18:58
• Updated: 28/Oct/11 06:06
• Resolved: 28/Oct/11 06:06

Description

dfs -mkdir /tmp/a;
dfs -mkdir /tmp/a/b;
dfs -mkdir /tmp/a/c;
create external table abc( key string, val string  )
partitioned by (part int)
location '/tmp/a/';

alter table abc ADD PARTITION (part=1)  LOCATION 'b';
alter table abc ADD PARTITION (part=2)  LOCATION 'c';

select key from abc where part=1;
select key from abct where part=70;