[BEAM-2160] add support Math functions

• Type: Task
• Status: Resolved
• Priority: P2
• Resolution: Fixed
• Fix Version/s: Not applicable
• Component/s: dsl-sql
• Labels: Done bundle dsl_sql_merge split
• Assignee: Tarush Grover
• Reporter: Mingmin Xu
• Created: 03/May/17 23:25
• Updated: 24/Jul/20 20:16
• Resolved: 19/Jul/17 01:19

Description

All Math functions listed as below:

POWER(numeric1, numeric2) 
ABS(numeric) 
MOD(numeric, numeric) 
SQRT(numeric) 	
LN(numeric) 	
LOG10(numeric) 
EXP(numeric) 	
CEIL(numeric) 
FLOOR(numeric) 	
RAND([seed]) 	
RAND_INTEGER([seed, ] numeric) 	
ACOS(numeric)
ASIN(numeric) 	
ATAN(numeric) 	
ATAN2(numeric, numeric) 	
COS(numeric) 	
COT(numeric) 	
DEGREES(numeric) 	
PI() 	
RADIANS(numeric) 	
ROUND(numeric1, numeric2) 	
SIGN(numeric) 	
SIN(numeric) 	
TAN(numeric) 	
TRUNCATE(numeric1, numeric2) 	

See https://calcite.apache.org/docs/reference.html#arithmetic-operators-and-functions for more details.

Issue Links

• contains: BEAM-2585 add math function RAND_INTEGER and RAND

Sub-Tasks

• Power function: Resolved
• ABS Function: Resolved
• MOD Function: Resolved
• SQRT Function: Resolved
• ROUND math function: Resolved
• CEIL, FLOOR, TRUNCATE, PI, ATAN2 math function: Resolved
• LN Function: Resolved
• LOG10 Function: Resolved
• EXP Function: Resolved
• ACOS, ASIN, ATAN, COS, COT, DEGREES, RADIANS, SIN, TAN, SIGN, LN, LOG10, EXP Functions: Resolved
• add math function RAND_INTEGER and RAND: Resolved