[ https://issues.apache.org/jira/browse/HIVE-5185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yin Huai updated HIVE-5185: --------------------------- Priority: Trivial (was: Minor) > test query files reduce_deduplicate_exclude_gby.q and reducesink_dedup.q are > useless > ------------------------------------------------------------------------------------ > > Key: HIVE-5185 > URL: https://issues.apache.org/jira/browse/HIVE-5185 > Project: Hive > Issue Type: Bug > Reporter: Yin Huai > Assignee: Yin Huai > Priority: Trivial > > The file "reduce_deduplicate_exclude_gby.q" contains > {code:sql} > create table t1( key_int1 int, key_int2 int, key_string1 string, key_string2 > string); > set hive.optimize.reducededuplication=false; > set hive.map.aggr=false; > select Q1.key_int1, sum(Q1.key_int1) from (select * from t1 cluster by > key_int1) Q1 group by Q1.key_int1; > drop table t1; > {code} > Since the table is not populated, there is no result will be in the .out file. > The same thing in "reducesink-dedup.q" > {code:sql} > DROP TABLE part; > -- data setup > CREATE TABLE part( > p_partkey INT, > p_name STRING, > p_mfgr STRING, > p_brand STRING, > p_type STRING, > p_size INT, > p_container STRING, > p_retailprice DOUBLE, > p_comment STRING > ); > select p_name > from (select p_name from part distribute by 1 sort by 1) p > distribute by 1 sort by 1 > ; > {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira