hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rohithsharma (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2271) InConsistency between Infomation Document and Actual Behavior for Built In Aggregate Functions(UDAF) Return Type.
Date Thu, 07 Jul 2011 12:32:20 GMT
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

        

Mime
View raw message