You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2015/06/16 02:02:58 UTC

[jira] [Commented] (PHOENIX-1660) Implement missing math built-in functions

    [ https://issues.apache.org/jira/browse/PHOENIX-1660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14587178#comment-14587178 ] 

Hudson commented on PHOENIX-1660:
---------------------------------

SUCCESS: Integrated in Phoenix-master #785 (See [https://builds.apache.org/job/Phoenix-master/785/])
PHOENIX-1660 Implement missing math built-in functions ABS, POWER, LN, LOG, SQRT, CBRT, EXP (Shuxiong Ye) (jamestaylor: rev c2927ddec5ab954dd779516ed29b4b7fa4b011d9)
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/AbsFunction.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/ExpressionType.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ExpFunctionEnd2EndIT.java
* phoenix-core/src/test/java/org/apache/phoenix/expression/ExpFunctionTest.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/ScalarFunction.java
* phoenix-core/src/test/java/org/apache/phoenix/expression/AbsFunctionTest.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/AbsFunctionEnd2EndIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/CbrtFunctionEnd2EndIT.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/SqrtFunction.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/JavaMathOneArgumentFunction.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/types/PRealNumber.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/LnFunction.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/PowerFunctionEnd2EndIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/LnLogFunctionEnd2EndIT.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/types/PWholeNumber.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/CbrtFunction.java
* phoenix-core/src/test/java/org/apache/phoenix/compile/QueryCompilerTest.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/PowerFunction.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/LogFunction.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/types/PNumericType.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/JavaMathTwoArgumentFunction.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/ExpFunction.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/types/PDecimal.java
* phoenix-core/src/test/java/org/apache/phoenix/expression/CbrtFunctionTest.java
* phoenix-core/src/test/java/org/apache/phoenix/expression/PowerFunctionTest.java
* phoenix-core/src/test/java/org/apache/phoenix/expression/LnLogFunctionTest.java


> Implement missing math built-in functions
> -----------------------------------------
>
>                 Key: PHOENIX-1660
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1660
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: Shuxiong Ye
>              Labels: Java, SQL, gsoc2015, mentor
>
> Take a look at the typical math functions that are implemented in relational database systems (http://www.postgresql.org/docs/current/static/functions-math.html) and implement the same for Phoenix in Java following this guide: http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html
> Examples of missing functions include POWER, LOG, EXP, SQRT, CBRT, etc. As a guide, examine how ROUND is implemented in Phoenix as an abstract function with concrete functions per type: long, decimal, and date/time types.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)