[
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
