[
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)