Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
0.6.0
-
None
-
Reviewed
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';
Attachments
Attachments
Issue Links
- is depended upon by
-
HIVE-1336 add an automated test for HIVE-1328
- Open