[PHOENIX-1660] Implement missing math built-in functions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.5.0
• Labels: Java SQL gsoc2015 mentor
• Assignee: Shuxiong Ye
• Reporter: James R. Taylor
• Created: 14/Feb/15 05:59
• Updated: 21/Nov/15 02:18
• Resolved: 16/Jun/15 00:23

Description

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.

Issue Links

• is cloned by: PHOENIX-1661 Implement built-in functions for JSON
• is cloned by: PHOENIX-1662 Implement missing date/time built-in functions and operators
• is cloned by: PHOENIX-1663 Implement missing string built-in functions
• is cloned by: PHOENIX-1664 Implement missing binary string built-in functions

Sub-Tasks

• Support ABS function: Closed
• Implement missing math built-in POWER function: Closed
• Implement Build-in math function Sign: Closed
• SIGN built-in function should be order preserving: Closed
• Implement Build-in math function CBRT: Closed
• Implement math build-in function SQRT: Closed
• Implement Build-in math function ln and log: Closed
• Implement build-in math function EXP: Closed
• Document new math built-in functions: Closed