{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/12373","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/12373/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/12373/comments","events_url":"https://api.github.com/repos/apache/spark/issues/12373/events","html_url":"https://github.com/apache/spark/pull/12373","id":148207803,"number":12373,"title":"[SPARK-14541] [SQL] [WIP] SQL function: IFNULL, NULLIF, NVL and NVL2","user":{"login":"bomeng","id":295781,"avatar_url":"https://avatars.githubusercontent.com/u/295781?v=3","gravatar_id":"","url":"https://api.github.com/users/bomeng","html_url":"https://github.com/bomeng","followers_url":"https://api.github.com/users/bomeng/followers","following_url":"https://api.github.com/users/bomeng/following{/other_user}","gists_url":"https://api.github.com/users/bomeng/gists{/gist_id}","starred_url":"https://api.github.com/users/bomeng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bomeng/subscriptions","organizations_url":"https://api.github.com/users/bomeng/orgs","repos_url":"https://api.github.com/users/bomeng/repos","events_url":"https://api.github.com/users/bomeng/events{/privacy}","received_events_url":"https://api.github.com/users/bomeng/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-04-13T23:08:31Z","updated_at":"2016-04-14T21:58:24Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/12373","html_url":"https://github.com/apache/spark/pull/12373","diff_url":"https://github.com/apache/spark/pull/12373.diff","patch_url":"https://github.com/apache/spark/pull/12373.patch"},"body":"## What changes were proposed in this pull request?\r\nI am trying to implement functions `NULLIF` in this PR. The meaning of NULLIF can be found here:\r\n[NULLIF( )](https://oracle-base.com/articles/misc/null-related-functions#nullif)\r\n[NVL( )](https://oracle-base.com/articles/misc/null-related-functions#nvl) / [IFNULL( )](https://www.1keydata.com/sql/sql-ifnull.html) `IFNULL()` and `NVL()` are the same.\r\n[NVL2( )](https://oracle-base.com/articles/misc/null-related-functions#nvl2)\r\n\r\n## How was this patch tested?\r\nTest cases were added.\r\n\r\n## JIRA related\r\n[SPAKR-14541](https://issues.apache.org/jira/browse/SPARK-14541)"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/210171609","html_url":"https://github.com/apache/spark/pull/12373#issuecomment-210171609","issue_url":"https://api.github.com/repos/apache/spark/issues/12373","id":210171609,"user":{"login":"SparkQA","id":8108735,"avatar_url":"https://avatars.githubusercontent.com/u/8108735?v=3","gravatar_id":"","url":"https://api.github.com/users/SparkQA","html_url":"https://github.com/SparkQA","followers_url":"https://api.github.com/users/SparkQA/followers","following_url":"https://api.github.com/users/SparkQA/following{/other_user}","gists_url":"https://api.github.com/users/SparkQA/gists{/gist_id}","starred_url":"https://api.github.com/users/SparkQA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SparkQA/subscriptions","organizations_url":"https://api.github.com/users/SparkQA/orgs","repos_url":"https://api.github.com/users/SparkQA/repos","events_url":"https://api.github.com/users/SparkQA/events{/privacy}","received_events_url":"https://api.github.com/users/SparkQA/received_events","type":"User","site_admin":false},"created_at":"2016-04-14T21:58:24Z","updated_at":"2016-04-14T21:58:24Z","body":"**[Test build #55845 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/55845/consoleFull)** for PR 12373 at commit [`de65cf4`](https://github.com/apache/spark/commit/de65cf4127bd269a517aa3c9e18b515f9afbf4bd).\n * This patch passes all tests.\n * This patch merges cleanly.\n * This patch adds no public classes."}}