[jira] [Resolved] (HIVE-2271) InConsistency between Infomation Document and Actual Behavior for Built In Aggregate Functions(UDAF) Return Type.

["Rohith Sharma K S (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-2271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rohith Sharma K S resolved HIVE-2271.
-------------------------------------
    Resolution: Cannot Reproduce

Closing as Can't Reproduce since  several releases has been given after this bug. And interestingly no one had looked it!!

> InConsistency between Infomation Document and Actual Behavior for Built In Aggregate Functions(UDAF) Return Type. 
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2271
>                 URL: https://issues.apache.org/jira/browse/HIVE-2271
>             Project: Hive
>          Issue Type: Bug
>          Components: Documentation, Query Processor
>    Affects Versions: 0.5.0, 0.6.0, 0.7.0, 0.7.1
>         Environment: SuSE-Linux-11
>            Reporter: Rohith Sharma K S
>
> I followed the Information Document for executing UDAF like MIN(),MAX(),SUM(),AVG() and COUNT() below link.
> [https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-BuiltinAggregateFunctions%28UDAF%29]
>  
> Observed mismatch for RETURN TYPE mentioned in Information Document and Actual Behavior.
> 1.) Return Type for min(colName),max(colName) is mentioned as DOUBLE,but while retrieving it is returning colName DataType passed to Min()/Max().
> Ex:
> 1).create table test(a int,b smallint,c string);
> 2).select min(a) from test;
> 3).ResultSet.getMetaData ().getColumnTypeName ( 1 )
>   Output : int
>   Expected : double(According to InformationDoc)
> 2.) Return Type for sum(colName) is mentioned as DOUBLE,but while retrieving it is always returning as BIGINT
> Ex:
> 1).create table test(a int,b smallint,c string);
> 2).select sum(a) from test;
> 3).ResultSet.getMetaData ().getColumnTypeName ( 1 )
>   Output : BIGINT
>   Expected : double(According to InformationDoc)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)