[jira] Commented: (HIVE-273) sum on a string column that has invalid input ignores the column where as avg treats it as NULL

["Ashish Thusoo (JIRA)" <ji...@apache.org>]

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