[
https://issues.apache.org/jira/browse/DRILL-8433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17721172#comment-17721172
]
ASF GitHub Bot commented on DRILL-8433:
---------------------------------------
cgivre opened a new pull request, #2801:
URL: https://github.com/apache/drill/pull/2801
# [DRILL-8433](https://issues.apache.org/jira/browse/DRILL-8433): Add
Percent Change UDF to Drill
## Description
Adds a new UDF, `percent_change(x,y)` which calculates the percent change
between the two variables. While this is relatively easy to do in SQL, it also
requires null and zero checks to prevent division by zero errors. This makes
this calculation simpler.
## Documentation
See README.
## Testing
Added unit tests.
> Add Percent Change UDF to Drill
> -------------------------------
>
> Key: DRILL-8433
> URL: https://issues.apache.org/jira/browse/DRILL-8433
> Project: Apache Drill
> Issue Type: Improvement
> Components: Functions - Drill
> Affects Versions: 1.21.1
> Reporter: Charles Givre
> Assignee: Charles Givre
> Priority: Major
> Fix For: 1.22.0
>
>
> Adds a function to calculate the percent change between two columns. Doing
> this without a custom function is cumbersome because you have to include a
> check for division by zero.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
