{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/6981","labels_url":"https://api.github.com/repos/apache/spark/issues/6981/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/6981/comments","events_url":"https://api.github.com/repos/apache/spark/issues/6981/events","html_url":"https://github.com/apache/spark/pull/6981","id":90614432,"number":6981,"title":"[SPARK-8199][SPARK-8184][SPARK-8183][SPARK-8182][SPARK-8181][SPARK-8180][SPARK-8179][SPARK-8177][SPARK-8178][SPARK-9115][SQL] date functions","user":{"login":"tarekauel","id":5320817,"avatar_url":"https://avatars.githubusercontent.com/u/5320817?v=3","gravatar_id":"","url":"https://api.github.com/users/tarekauel","html_url":"https://github.com/tarekauel","followers_url":"https://api.github.com/users/tarekauel/followers","following_url":"https://api.github.com/users/tarekauel/following{/other_user}","gists_url":"https://api.github.com/users/tarekauel/gists{/gist_id}","starred_url":"https://api.github.com/users/tarekauel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tarekauel/subscriptions","organizations_url":"https://api.github.com/users/tarekauel/orgs","repos_url":"https://api.github.com/users/tarekauel/repos","events_url":"https://api.github.com/users/tarekauel/events{/privacy}","received_events_url":"https://api.github.com/users/tarekauel/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":138,"created_at":"2015-06-24T08:53:02Z","updated_at":"2015-07-17T21:21:36Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/6981","html_url":"https://github.com/apache/spark/pull/6981","diff_url":"https://github.com/apache/spark/pull/6981.diff","patch_url":"https://github.com/apache/spark/pull/6981.patch"},"body":"Jira:\r\nhttps://issues.apache.org/jira/browse/SPARK-8199\r\nhttps://issues.apache.org/jira/browse/SPARK-8184\r\nhttps://issues.apache.org/jira/browse/SPARK-8183\r\nhttps://issues.apache.org/jira/browse/SPARK-8182\r\nhttps://issues.apache.org/jira/browse/SPARK-8181\r\nhttps://issues.apache.org/jira/browse/SPARK-8180\r\nhttps://issues.apache.org/jira/browse/SPARK-8179\r\nhttps://issues.apache.org/jira/browse/SPARK-8177\r\nhttps://issues.apache.org/jira/browse/SPARK-8179\r\nhttps://issues.apache.org/jira/browse/SPARK-9115\r\n\r\nRegarding `day`and `dayofmonth` are both necessary?\r\n\r\n~~I am going to add `Quarter` to this PR as well.~~ Done.\r\n\r\n~~As soon as the Scala coding is reviewed and discussed, I'll add the python api.~~ Done"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/122421520","html_url":"https://github.com/apache/spark/pull/6981#issuecomment-122421520","issue_url":"https://api.github.com/repos/apache/spark/issues/6981","id":122421520,"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-07-17T21:21:36Z","updated_at":"2015-07-17T21:21:36Z","body":"  [Test build #37659 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/37659/console) for   PR 6981 at commit [`fb98ba0`](https://github.com/apache/spark/commit/fb98ba02d7485e50aab7cc387ca68b426b7058cf).\n * This patch **fails PySpark unit tests**.\n * This patch merges cleanly.\n * This patch adds the following public classes _(experimental)_:\n  * `case class Hour(child: Expression) extends UnaryExpression with ImplicitCastInputTypes `\n  * `case class Minute(child: Expression) extends UnaryExpression with ImplicitCastInputTypes `\n  * `case class Second(child: Expression) extends UnaryExpression with ImplicitCastInputTypes `\n  * `case class DayInYear(child: Expression) extends UnaryExpression with ImplicitCastInputTypes `\n  * `case class Year(child: Expression) extends UnaryExpression with ImplicitCastInputTypes `\n  * `case class Quarter(child: Expression) extends UnaryExpression with ImplicitCastInputTypes `\n  * `case class Month(child: Expression) extends UnaryExpression with ImplicitCastInputTypes `\n  * `case class Day(child: Expression) extends UnaryExpression with ImplicitCastInputTypes `\n  * `case class WeekOfYear(child: Expression) extends UnaryExpression with ImplicitCastInputTypes `\n  * `case class DateFormatClass(left: Expression, right: Expression) extends BinaryExpression`\n"}}