[ https://issues.apache.org/jira/browse/HIVE-5185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yin Huai updated HIVE-5185: --------------------------- Description: 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} {/code} was: The file 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. > 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: Minor > > 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} > {/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