[HIVE-1328] make mapred.input.dir.recursive work for select *

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6.0
• Fix Version/s: 0.6.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: John Sichi
• Reporter: John Sichi
• Created: 28/Apr/10 20:17
• Updated: 02/May/13 02:29
• Resolved: 05/May/10 05:26

Description

For the script below, we would like the behavior from MAPREDUCE-1501 to apply so that the select * returns two rows instead of none.

create table fact_daily(x int)
partitioned by (ds string);

create table fact_tz(x int)
partitioned by (ds string, hr string, gmtoffset string);

alter table fact_tz
add partition (ds='2010-01-03', hr='1', gmtoffset='-8');
insert overwrite table fact_tz
partition (ds='2010-01-03', hr='1', gmtoffset='-8')
select key+11 from src where key=484;

alter table fact_tz
add partition (ds='2010-01-03', hr='2', gmtoffset='-7');
insert overwrite table fact_tz
partition (ds='2010-01-03', hr='2', gmtoffset='-7')
select key+12 from src where key=484;

alter table fact_daily
set tblproperties('EXTERNAL'='TRUE');

alter table fact_daily
add partition (ds='2010-01-03')
location '/user/hive/warehouse/fact_tz/ds=2010-01-03';

set mapred.input.dir.recursive=true;
select * from fact_daily where ds='2010-01-03';

Issue Links

• is depended upon by: HIVE-1336 add an automated test for HIVE-1328