hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yin Huai (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-5185) test query files reduce_deduplicate_exclude_gby.q and reducesink_dedup.q are useless
Date Fri, 30 Aug 2013 15:03:52 GMT

     [ 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

Mime
View raw message