Review Board 1.7.22


DRILL-199 : floor() and ceil() functions implementation

Review Request #14015 - Created Sept. 6, 2013 and updated

Yash Sharma
Reviewers
drill-git
drill-git
Have added drill functions to MathFunctions for floor and ceil methods. Have tested the method with the below queries:

0: jdbc:drill:schema=parquet-local> SELECT ceil(1.768) as ceil_value FROM "sample-data/region.parquet";
+-------------+
| CEIL_VALUE  |
+-------------+
| 2.0         |
| 2.0         |
| 2.0         |
| 2.0         |
| 2.0         |
+-------------+
5 rows selected (0.638 seconds)


0: jdbc:drill:schema=parquet-local> SELECT floor(1.768) as floor_value FROM "sample-data/region.parquet";
+--------------+
| FLOOR_VALUE  |
+--------------+
| 1.0          |
| 1.0          |
| 1.0          |
| 1.0          |
| 1.0          |
+--------------+
5 rows selected (0.485 seconds)

Testing done on sqlline prompt. 
Testing done by test case:
$ mvn test -Dtest=RunSimplePlan#mathCeilFloorPlan

Review request changed
Updated (Sept. 24, 2013, 9:13 a.m.)