[
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 "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}
> 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
