----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/29439/#review67052 -----------------------------------------------------------
Ship it! Ship It! - John Pullokkaran On Jan. 7, 2015, 2:12 a.m., pengcheng xiong wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/29439/ > ----------------------------------------------------------- > > (Updated Jan. 7, 2015, 2:12 a.m.) > > > Review request for hive and John Pullokkaran. > > > Repository: hive-git > > > Description > ------- > > In union_remove_6.q, just change > > FROM ( > SELECT key, count(1) as values from inputTbl1 group by key > UNION ALL > SELECT key, count(1) as values from inputTbl1 group by key > ) a > insert overwrite table outputTbl1 select * > insert overwrite table outputTbl2 select *; > > to > > FROM ( > select * from( > SELECT key, count(1) as values from inputTbl1 group by key > UNION ALL > SELECT key, count(1) as values from inputTbl1 group by key > )subq > ) a > insert overwrite table outputTbl1 select * > insert overwrite table outputTbl2 select *; > > select * from outputtbl2 will output nothing > > > Diffs > ----- > > > ql/src/java/org/apache/hadoop/hive/ql/optimizer/unionproc/UnionProcFactory.java > a985c4f > ql/src/test/queries/clientpositive/union_remove_6_subq.q PRE-CREATION > ql/src/test/results/clientpositive/union_remove_6_subq.q.out PRE-CREATION > > Diff: https://reviews.apache.org/r/29439/diff/ > > > Testing > ------- > > > Thanks, > > pengcheng xiong > >
