You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zheng Shao (JIRA)" <ji...@apache.org> on 2009/02/04 06:03:59 UTC

[jira] Created: (HIVE-269) Add log/exp UDF functions to Hive

Add log/exp UDF functions to Hive
---------------------------------

                 Key: HIVE-269
                 URL: https://issues.apache.org/jira/browse/HIVE-269
             Project: Hadoop Hive
          Issue Type: New Feature
          Components: Query Processor
    Affects Versions: 0.2.0
            Reporter: Zheng Shao
            Assignee: Zheng Shao


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

{code}
EXP() 	Raise to the power of
LN() 	Return the natural logarithm of the argument
LOG10() 	Return the base-10 logarithm of the argument
LOG2() 	Return the base-2 logarithm of the argument
LOG() 	Return the natural logarithm of the first argument 
{code}


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


[jira] Updated: (HIVE-269) Add log/exp UDF functions to Hive

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

Zheng Shao updated HIVE-269:
----------------------------

    Attachment: HIVE-269.2.patch

Added javadoc comment.

> Add log/exp UDF functions to Hive
> ---------------------------------
>
>                 Key: HIVE-269
>                 URL: https://issues.apache.org/jira/browse/HIVE-269
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>         Attachments: HIVE-269.1.patch, HIVE-269.2.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
> {code}
> EXP() 	Raise to the power of
> LN() 	Return the natural logarithm of the argument
> LOG10() 	Return the base-10 logarithm of the argument
> LOG2() 	Return the base-2 logarithm of the argument
> LOG() 	Return the natural logarithm of the first argument 
> POW() 	Return the argument raised to the specified power
> POWER() 	Return the argument raised to the specified power
> {code}

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


[jira] Commented: (HIVE-269) Add log/exp UDF functions to Hive

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

Jeff Hammerbacher commented on HIVE-269:
----------------------------------------

https://issues.apache.org/jira/browse/HIVE-245 has POW(X, Y) open, so make sure to close that as a dupe if you do POW here?

> Add log/exp UDF functions to Hive
> ---------------------------------
>
>                 Key: HIVE-269
>                 URL: https://issues.apache.org/jira/browse/HIVE-269
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>         Attachments: HIVE-269.1.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
> {code}
> EXP() 	Raise to the power of
> LN() 	Return the natural logarithm of the argument
> LOG10() 	Return the base-10 logarithm of the argument
> LOG2() 	Return the base-2 logarithm of the argument
> LOG() 	Return the natural logarithm of the first argument 
> POW() 	Return the argument raised to the specified power
> POWER() 	Return the argument raised to the specified power
> {code}

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


[jira] Resolved: (HIVE-269) Add log/exp UDF functions to Hive

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

Zheng Shao resolved HIVE-269.
-----------------------------

       Resolution: Fixed
    Fix Version/s: 0.3.0
                   0.2.0
     Release Note: HIVE-269. Add log/exp/pow UDF functions to Hive. (zshao)
     Hadoop Flags: [Reviewed]

Committed revision 741366 for trunk.
Committed revision 741367 and 741368 for branch 0.2.


> Add log/exp UDF functions to Hive
> ---------------------------------
>
>                 Key: HIVE-269
>                 URL: https://issues.apache.org/jira/browse/HIVE-269
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>             Fix For: 0.2.0, 0.3.0
>
>         Attachments: HIVE-269.1.patch, HIVE-269.2.patch, HIVE-269.3.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
> {code}
> EXP() 	Raise to the power of
> LN() 	Return the natural logarithm of the argument
> LOG10() 	Return the base-10 logarithm of the argument
> LOG2() 	Return the base-2 logarithm of the argument
> LOG() 	Return the natural logarithm of the first argument 
> POW() 	Return the argument raised to the specified power
> POWER() 	Return the argument raised to the specified power
> {code}

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


[jira] Updated: (HIVE-269) Add log/exp UDF functions to Hive

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

Zheng Shao updated HIVE-269:
----------------------------

    Attachment: HIVE-269.3.patch

Corrected the comments.


> Add log/exp UDF functions to Hive
> ---------------------------------
>
>                 Key: HIVE-269
>                 URL: https://issues.apache.org/jira/browse/HIVE-269
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>         Attachments: HIVE-269.1.patch, HIVE-269.2.patch, HIVE-269.3.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
> {code}
> EXP() 	Raise to the power of
> LN() 	Return the natural logarithm of the argument
> LOG10() 	Return the base-10 logarithm of the argument
> LOG2() 	Return the base-2 logarithm of the argument
> LOG() 	Return the natural logarithm of the first argument 
> POW() 	Return the argument raised to the specified power
> POWER() 	Return the argument raised to the specified power
> {code}

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


[jira] Commented: (HIVE-269) Add log/exp UDF functions to Hive

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

Jeff Hammerbacher commented on HIVE-269:
----------------------------------------

Looks good, with one tiny nit: add "base" to the javadoc:

/**
 * Returns the logarithm of a with base. 
 */

should be:

/**
 * Returns the logarithm of a with base "base".
 */

> Add log/exp UDF functions to Hive
> ---------------------------------
>
>                 Key: HIVE-269
>                 URL: https://issues.apache.org/jira/browse/HIVE-269
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>         Attachments: HIVE-269.1.patch, HIVE-269.2.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
> {code}
> EXP() 	Raise to the power of
> LN() 	Return the natural logarithm of the argument
> LOG10() 	Return the base-10 logarithm of the argument
> LOG2() 	Return the base-2 logarithm of the argument
> LOG() 	Return the natural logarithm of the first argument 
> POW() 	Return the argument raised to the specified power
> POWER() 	Return the argument raised to the specified power
> {code}

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


[jira] Commented: (HIVE-269) Add log/exp UDF functions to Hive

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

Zheng Shao commented on HIVE-269:
---------------------------------

Added the UDFs to the wiki.


> Add log/exp UDF functions to Hive
> ---------------------------------
>
>                 Key: HIVE-269
>                 URL: https://issues.apache.org/jira/browse/HIVE-269
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>             Fix For: 0.2.0, 0.3.0
>
>         Attachments: HIVE-269.1.patch, HIVE-269.2.patch, HIVE-269.3.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
> {code}
> EXP() 	Raise to the power of
> LN() 	Return the natural logarithm of the argument
> LOG10() 	Return the base-10 logarithm of the argument
> LOG2() 	Return the base-2 logarithm of the argument
> LOG() 	Return the natural logarithm of the first argument 
> POW() 	Return the argument raised to the specified power
> POWER() 	Return the argument raised to the specified power
> {code}

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


[jira] Updated: (HIVE-269) Add log/exp UDF functions to Hive

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

Zheng Shao updated HIVE-269:
----------------------------

    Attachment: HIVE-269.1.patch

Although this functionality is new, there is little chance that this transaction will break other existing things.

I proposed to commit it to both branch 0.2 and trunk.


> Add log/exp UDF functions to Hive
> ---------------------------------
>
>                 Key: HIVE-269
>                 URL: https://issues.apache.org/jira/browse/HIVE-269
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>         Attachments: HIVE-269.1.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
> {code}
> EXP() 	Raise to the power of
> LN() 	Return the natural logarithm of the argument
> LOG10() 	Return the base-10 logarithm of the argument
> LOG2() 	Return the base-2 logarithm of the argument
> LOG() 	Return the natural logarithm of the first argument 
> {code}

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


[jira] Updated: (HIVE-269) Add log/exp UDF functions to Hive

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

Zheng Shao updated HIVE-269:
----------------------------

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

{code}
EXP() 	Raise to the power of
LN() 	Return the natural logarithm of the argument
LOG10() 	Return the base-10 logarithm of the argument
LOG2() 	Return the base-2 logarithm of the argument
LOG() 	Return the natural logarithm of the first argument 
POW() 	Return the argument raised to the specified power
POWER() 	Return the argument raised to the specified power
{code}


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

{code}
EXP() 	Raise to the power of
LN() 	Return the natural logarithm of the argument
LOG10() 	Return the base-10 logarithm of the argument
LOG2() 	Return the base-2 logarithm of the argument
LOG() 	Return the natural logarithm of the first argument 
{code}



> Add log/exp UDF functions to Hive
> ---------------------------------
>
>                 Key: HIVE-269
>                 URL: https://issues.apache.org/jira/browse/HIVE-269
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.2.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>         Attachments: HIVE-269.1.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
> {code}
> EXP() 	Raise to the power of
> LN() 	Return the natural logarithm of the argument
> LOG10() 	Return the base-10 logarithm of the argument
> LOG2() 	Return the base-2 logarithm of the argument
> LOG() 	Return the natural logarithm of the first argument 
> POW() 	Return the argument raised to the specified power
> POWER() 	Return the argument raised to the specified power
> {code}

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


[jira] Updated: (HIVE-269) Add log/exp UDF functions to Hive

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

Carl Steinbach updated HIVE-269:
--------------------------------

    Affects Version/s:     (was: 0.6.0)
                       0.3.0
        Fix Version/s:     (was: 0.6.0)

> Add log/exp UDF functions to Hive
> ---------------------------------
>
>                 Key: HIVE-269
>                 URL: https://issues.apache.org/jira/browse/HIVE-269
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.3.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>             Fix For: 0.3.0
>
>         Attachments: HIVE-269.1.patch, HIVE-269.2.patch, HIVE-269.3.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
> {code}
> EXP() 	Raise to the power of
> LN() 	Return the natural logarithm of the argument
> LOG10() 	Return the base-10 logarithm of the argument
> LOG2() 	Return the base-2 logarithm of the argument
> LOG() 	Return the natural logarithm of the first argument 
> POW() 	Return the argument raised to the specified power
> POWER() 	Return the argument raised to the specified power
> {code}

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