{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/10056","labels_url":"https://api.github.com/repos/apache/spark/issues/10056/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/10056/comments","events_url":"https://api.github.com/repos/apache/spark/issues/10056/events","html_url":"https://github.com/apache/spark/pull/10056","id":119634628,"number":10056,"title":"[SPARK-12067] [SQL] Fix usage of isnan, isnull, isnotnull of Column and DataFrame","user":{"login":"yanboliang","id":1962026,"avatar_url":"https://avatars.githubusercontent.com/u/1962026?v=3","gravatar_id":"","url":"https://api.github.com/users/yanboliang","html_url":"https://github.com/yanboliang","followers_url":"https://api.github.com/users/yanboliang/followers","following_url":"https://api.github.com/users/yanboliang/following{/other_user}","gists_url":"https://api.github.com/users/yanboliang/gists{/gist_id}","starred_url":"https://api.github.com/users/yanboliang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yanboliang/subscriptions","organizations_url":"https://api.github.com/users/yanboliang/orgs","repos_url":"https://api.github.com/users/yanboliang/repos","events_url":"https://api.github.com/users/yanboliang/events{/privacy}","received_events_url":"https://api.github.com/users/yanboliang/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-01T03:32:26Z","updated_at":"2015-12-01T05:42:48Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/10056","html_url":"https://github.com/apache/spark/pull/10056","diff_url":"https://github.com/apache/spark/pull/10056.diff","patch_url":"https://github.com/apache/spark/pull/10056.patch"},"body":"This PR including the following changes:\r\n* #9930 has deprecated ```DataFrame.isNaN, DataFrame.isNull``` and replaced by ```DataFrame.isnan, DataFrame.isnull```, in this PR we changed ```Column.isNaN``` to ```Column.isnan```, ```Column.isNull``` to ```Column.isnull```, ```Column.isNotNull``` to ```Column.isnotnull```.\r\n* Add ```Column.notnull``` as alias of ```Column.isnotnull``` following the [pandas](http://pandas.pydata.org/pandas-docs/version/0.17.1/generated/pandas.notnull.html) naming convention. \r\n* Add ```DataFrame.isnotnull``` and ```DataFrame.notnull```.\r\n\r\nTodo:\r\nIf this PR has been accepted, I can do the peer renaming for Python and R in a follow-up PR.\r\n\r\ncc @rxin @marmbrus @davies "},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/160859331","html_url":"https://github.com/apache/spark/pull/10056#issuecomment-160859331","issue_url":"https://api.github.com/repos/apache/spark/issues/10056","id":160859331,"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":"2015-12-01T05:42:48Z","updated_at":"2015-12-01T05:42:48Z","body":"**[Test build #46936 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/46936/consoleFull)** for PR 10056 at commit [`edf7e7b`](https://github.com/apache/spark/commit/edf7e7bd6881462fed33ea6b285f4ef85b2cbe33).\n * This patch passes all tests.\n * This patch merges cleanly.\n * This patch adds no public classes."}}