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.7.1, 0.7.0, 0.6.0, 0.5.0
Environment: SuSE-Linux-11
Reporter: rohithsharma
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 is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
