You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashish Thusoo (JIRA)" <ji...@apache.org> on 2009/02/05 00:20:59 UTC
[jira] Created: (HIVE-273) sum on a string column that has invalid
input ignores the column where as avg treats it as NULL
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.
[jira] Updated: (HIVE-273) regression: avg always returns NULL
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Thusoo updated HIVE-273:
-------------------------------
Status: Patch Available (was: Open)
submitted.
> regression: avg always returns 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
> Priority: Blocker
> Attachments: patch-273.txt
>
>
> Due to recent checkin for implict type conversion, avg broke and it always returns NULLs.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-273) sum on a string column that has
invalid input ignores the column where as avg treats it as NULL
Posted by "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.
[jira] Updated: (HIVE-273) regression: avg always returns NULL
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-273:
--------------------------------
Fix Version/s: 0.3.0
(was: 0.6.0)
Affects Version/s: (was: 0.6.0)
> regression: avg always returns NULL
> -----------------------------------
>
> Key: HIVE-273
> URL: https://issues.apache.org/jira/browse/HIVE-273
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Ashish Thusoo
> Assignee: Ashish Thusoo
> Priority: Blocker
> Fix For: 0.3.0
>
> Attachments: patch-273.txt, patch-273_2.txt
>
>
> Due to recent checkin for implict type conversion, avg broke and it always returns NULLs.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-273) regression: avg always returns NULL
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Thusoo updated HIVE-273:
-------------------------------
Attachment: patch-273_2.txt
Fixed some test outputs.
> regression: avg always returns 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
> Priority: Blocker
> Attachments: patch-273.txt, patch-273_2.txt
>
>
> Due to recent checkin for implict type conversion, avg broke and it always returns NULLs.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-273) regression: avg always returns NULL
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Thusoo updated HIVE-273:
-------------------------------
Description: Due to recent checkin for implict type conversion, avg broke and it always returns NULLs. (was: sum on a string column that has invalid input ignores the column where as avg treats it as NULL)
Priority: Blocker (was: Major)
Summary: regression: avg always returns NULL (was: sum on a string column that has invalid input ignores the column where as avg treats it as NULL)
Fixing the description and summary to reflect the seriousness of the bug.
> regression: avg always returns 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
> Priority: Blocker
>
> Due to recent checkin for implict type conversion, avg broke and it always returns NULLs.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-273) regression: avg always returns NULL
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Thusoo updated HIVE-273:
-------------------------------
Resolution: Fixed
Fix Version/s: 0.2.0
Hadoop Flags: [Reviewed]
Status: Resolved (was: Patch Available)
committed.
> regression: avg always returns 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
> Priority: Blocker
> Fix For: 0.2.0
>
> Attachments: patch-273.txt, patch-273_2.txt
>
>
> Due to recent checkin for implict type conversion, avg broke and it always returns NULLs.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-273) regression: avg always returns NULL
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Thusoo updated HIVE-273:
-------------------------------
Attachment: patch-273.txt
Patch attached.
> regression: avg always returns 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
> Priority: Blocker
> Attachments: patch-273.txt
>
>
> Due to recent checkin for implict type conversion, avg broke and it always returns NULLs.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-273) regression: avg always returns NULL
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12670952#action_12670952 ]
Zheng Shao commented on HIVE-273:
---------------------------------
+1.
> regression: avg always returns 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
> Priority: Blocker
> Attachments: patch-273.txt, patch-273_2.txt
>
>
> Due to recent checkin for implict type conversion, avg broke and it always returns NULLs.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.