GitHub user chezou opened a pull request:
https://github.com/apache/incubator-hivemall/pull/160
[HIVEMALL-163] Add IS_INFINITE, IS_FINITE, IS_NAN functions
## What changes were proposed in this pull request?
Add Floating point functions: infinity, is_finite, is_infinite, is_nan, nan
## What type of PR is it?
Feature
## What is the Jira issue?
https://issues.apache.org/jira/browse/HIVEMALL-163
## How was this patch tested?
Unit tests
## How to use this feature?
```sql
select is_infinite(infinity());
select is_infinite(1.0);
select is_finite(infinity());
select is_finite(1.0);
select nan();
select is_nan(nan());
select is_nan(10.0);
```
## Checklist
- [x] Did you apply source code formatter, i.e., `./bin/format_code.sh`,
for your commit?
- [x] Did you run system tests on Hive (or Spark)?
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/chezou/incubator-hivemall HIVEMALL-163
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hivemall/pull/160.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #160
----
commit 76a487541680b93dd7d5dc704c6f03a5d8294a4f
Author: Aki Ariga <ariga@...>
Date: 2018-09-03T08:14:34Z
Add Floating point functions: infinity, is_finite, is_infinite, is_nan, nan
commit 6c4827f0223fe0d2c3b0501f1bc3d808494583d0
Author: Aki Ariga <ariga@...>
Date: 2018-09-03T09:01:35Z
Add license header
commit 79439fdf9ac92437d678d1208a8deb88bb06f486
Author: Aki Ariga <ariga@...>
Date: 2018-09-03T09:01:54Z
Update Generic function lists in doc
commit 146ad6addfe54d42213ebb9696ae5aaf5b7182a6
Author: Aki Ariga <ariga@...>
Date: 2018-09-03T09:07:11Z
Add update_func_md.sh on README.md for contribution
----
---
