hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Thusoo (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-273) sum on a string column that has invalid input ignores the column where as avg treats it as NULL
Date Wed, 04 Feb 2009 23:20:59 GMT

    [ https://issues.apache.org/jira/browse/HIVE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12670550#action_12670550
] 

Ashish Thusoo commented on HIVE-273:
------------------------------------

The following test case shows the error:

Suppose table T(string c1) has 2 rows

''
'1'

then 

select avg(c1), sum(c1), count(c1) from T

returns

NULL   1.0   1


> sum on a string column that has invalid input ignores the column where as avg treats
it as NULL
> -----------------------------------------------------------------------------------------------
>
>                 Key: HIVE-273
>                 URL: https://issues.apache.org/jira/browse/HIVE-273
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Ashish Thusoo
>            Assignee: Ashish Thusoo
>
> sum on a string column that has invalid input ignores the column where as avg treats
it as NULL

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message