[jira] Commented: (HIVE-408) UDAFCount should count empty strings

["Edward Capriolo (JIRA)" <ji...@apache.org>]

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

Edward Capriolo commented on HIVE-408:
--------------------------------------

Zheng, 
I submitted a patch. Today I am targeting low hanging-fruit. I hope this is not anything you were looking forward to doing :)

http://en.wikipedia.org/wiki/Null_(SQL)

If one is not interested in reading the reference it works like:

mysql> use test;
mysql> create table the_null( a int);
mysql> insert into the_null (a) values (NULL);
Query OK, 1 row affected (0.04 sec)

mysql> select * from the_null;
+------+
| a    |
+------+
| NULL | 
+------+
1 row in set (0.04 sec)

mysql> select count(a) from the_null;
+----------+
| count(a) |
+----------+
|        0 | 
+----------+
1 row in set (0.08 sec)

mysql> select count(*) from the_null;
+----------+
| count(*) |
+----------+
|        1 | 
+----------+
1 row in set (0.00 sec)


> UDAFCount should count empty strings
> ------------------------------------
>
>                 Key: HIVE-408
>                 URL: https://issues.apache.org/jira/browse/HIVE-408
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>         Attachments: hive-408.diff
>
>
> UDAFCount is not counting empty strings right now. We should count that according to SQL standard. (Null is not counted.)

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