[ https://issues.apache.org/jira/browse/PHOENIX-1687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shuxiong Ye updated PHOENIX-1687: --------------------------------- Attachment: add-function-PHOENIX-1611-1687-2015-2019-2020_v2.patch Hi [~jamestaylor], This new patch contains several build-in math functions. What's new: 1. Remove abstract function in JavaMathTwoArgumentFunction, and use annotation, instead. 2. Modify ScalarFunction's getKeyFormationTraversalIndex() and update its doc. 3. Add negative test in QueryCompilerTest. For NaN problem, I've done some experiment in mysql. For details, see[1]. And this patch has to update for it, yet. That is, the function still return NaN, in this patch. Thanks. [1] https://issues.apache.org/jira/browse/PHOENIX-1987?focusedCommentId=14583762&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14583762 > Implement missing math built-in POWER function > ---------------------------------------------- > > Key: PHOENIX-1687 > URL: https://issues.apache.org/jira/browse/PHOENIX-1687 > Project: Phoenix > Issue Type: Sub-task > Reporter: Aakarsh Agarwal > Assignee: Shuxiong Ye > Labels: gsoc2015, java > Fix For: 5.0.0, 4.5.0 > > Attachments: add-function-PHOENIX-1611-1687-2015-2019-2020_v2.patch > > > 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 > For this specific task, it is meant to implement missing funstion POWER for > Phoenix in Java. -- This message was sent by Atlassian JIRA (v6.3.4#6332)