You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Jeff Hammerbacher (JIRA)" <ji...@apache.org> on 2009/01/23 10:18:59 UTC

[jira] Created: (HIVE-244) Add SQRT() UDF

Add SQRT() UDF
--------------

                 Key: HIVE-244
                 URL: https://issues.apache.org/jira/browse/HIVE-244
             Project: Hadoop Hive
          Issue Type: New Feature
            Reporter: Jeff Hammerbacher
            Priority: Minor


See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_sqrt.

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


[jira] Updated: (HIVE-244) Add SQRT() UDF

Posted by "Jeff Hammerbacher (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Hammerbacher updated HIVE-244:
-----------------------------------

    Status: Patch Available  (was: Open)

> Add SQRT() UDF
> --------------
>
>                 Key: HIVE-244
>                 URL: https://issues.apache.org/jira/browse/HIVE-244
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Jeff Hammerbacher
>            Priority: Minor
>         Attachments: HIVE-244.diff, HIVE-244.testoutput
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_sqrt.

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


[jira] Updated: (HIVE-244) Add SQRT() UDF

Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zheng Shao updated HIVE-244:
----------------------------

       Resolution: Fixed
    Fix Version/s: 0.2.0
     Release Note: HIVE-244. Add SQRT() UDF. (Jeff Hammerbacher via zshao)
     Hadoop Flags: [Reviewed]
           Status: Resolved  (was: Patch Available)

Committed revision 737956. Thanks Jeff!


> Add SQRT() UDF
> --------------
>
>                 Key: HIVE-244
>                 URL: https://issues.apache.org/jira/browse/HIVE-244
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Jeff Hammerbacher
>            Priority: Minor
>             Fix For: 0.2.0
>
>         Attachments: HIVE-244.diff, HIVE-244.diff.2, HIVE-244.testoutput
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_sqrt.

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


[jira] Updated: (HIVE-244) Add SQRT() UDF

Posted by "Jeff Hammerbacher (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Hammerbacher updated HIVE-244:
-----------------------------------

    Attachment: HIVE-244.diff.2

Added terse javadocs.

> Add SQRT() UDF
> --------------
>
>                 Key: HIVE-244
>                 URL: https://issues.apache.org/jira/browse/HIVE-244
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Jeff Hammerbacher
>            Priority: Minor
>         Attachments: HIVE-244.diff, HIVE-244.diff.2, HIVE-244.testoutput
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_sqrt.

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


[jira] Commented: (HIVE-244) Add SQRT() UDF

Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12667489#action_12667489 ] 

Zheng Shao commented on HIVE-244:
---------------------------------

Testing now. Will commit when done.


> Add SQRT() UDF
> --------------
>
>                 Key: HIVE-244
>                 URL: https://issues.apache.org/jira/browse/HIVE-244
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Jeff Hammerbacher
>            Priority: Minor
>         Attachments: HIVE-244.diff, HIVE-244.diff.2, HIVE-244.testoutput
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_sqrt.

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


[jira] Updated: (HIVE-244) Add SQRT() UDF

Posted by "Jeff Hammerbacher (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Hammerbacher updated HIVE-244:
-----------------------------------

    Attachment: HIVE-244.testoutput
                HIVE-244.diff

test output (for the test run below) is also attached.

$ ant test -Dtestcase=TestCliDriver -Dqfile=udf4.q


> Add SQRT() UDF
> --------------
>
>                 Key: HIVE-244
>                 URL: https://issues.apache.org/jira/browse/HIVE-244
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Jeff Hammerbacher
>            Priority: Minor
>         Attachments: HIVE-244.diff, HIVE-244.testoutput
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_sqrt.

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


[jira] Updated: (HIVE-244) Add SQRT() UDF

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach updated HIVE-244:
--------------------------------

    Fix Version/s: 0.3.0
                       (was: 0.6.0)
      Component/s: UDF

> Add SQRT() UDF
> --------------
>
>                 Key: HIVE-244
>                 URL: https://issues.apache.org/jira/browse/HIVE-244
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: UDF
>            Reporter: Jeff Hammerbacher
>            Priority: Minor
>             Fix For: 0.3.0
>
>         Attachments: HIVE-244.diff, HIVE-244.diff.2, HIVE-244.testoutput
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_sqrt.

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


[jira] Commented: (HIVE-244) Add SQRT() UDF

Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12667466#action_12667466 ] 

Ashish Thusoo commented on HIVE-244:
------------------------------------

Looks fine to me. A small nit - could you add a javadocs to the evaluate function and to the class UDFSqrt.

Thanks,
Ashish

> Add SQRT() UDF
> --------------
>
>                 Key: HIVE-244
>                 URL: https://issues.apache.org/jira/browse/HIVE-244
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Jeff Hammerbacher
>            Priority: Minor
>         Attachments: HIVE-244.diff, HIVE-244.testoutput
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_sqrt.

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


[jira] Commented: (HIVE-244) Add SQRT() UDF

Posted by "Jeff Hammerbacher (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12667011#action_12667011 ] 

Jeff Hammerbacher commented on HIVE-244:
----------------------------------------

This implementation will return NULL if you take the sqrt of a negative number, as MySQL does.

> Add SQRT() UDF
> --------------
>
>                 Key: HIVE-244
>                 URL: https://issues.apache.org/jira/browse/HIVE-244
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Jeff Hammerbacher
>            Priority: Minor
>         Attachments: HIVE-244.diff, HIVE-244.testoutput
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_sqrt.

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