{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/5045","labels_url":"https://api.github.com/repos/apache/spark/issues/5045/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/5045/comments","events_url":"https://api.github.com/repos/apache/spark/issues/5045/events","html_url":"https://github.com/apache/spark/pull/5045","id":62065168,"number":5045,"title":"[SPARK-6356][SQL] Support the ROLLUP/CUBE/GROUPING SETS/GROUPING() in SQLContext","user":{"login":"watermen","id":1400819,"avatar_url":"https://avatars.githubusercontent.com/u/1400819?v=3","gravatar_id":"","url":"https://api.github.com/users/watermen","html_url":"https://github.com/watermen","followers_url":"https://api.github.com/users/watermen/followers","following_url":"https://api.github.com/users/watermen/following{/other_user}","gists_url":"https://api.github.com/users/watermen/gists{/gist_id}","starred_url":"https://api.github.com/users/watermen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/watermen/subscriptions","organizations_url":"https://api.github.com/users/watermen/orgs","repos_url":"https://api.github.com/users/watermen/repos","events_url":"https://api.github.com/users/watermen/events{/privacy}","received_events_url":"https://api.github.com/users/watermen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-03-16T12:32:22Z","updated_at":"2015-03-18T01:56:42Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/5045","html_url":"https://github.com/apache/spark/pull/5045","diff_url":"https://github.com/apache/spark/pull/5045.diff","patch_url":"https://github.com/apache/spark/pull/5045.patch"},"body":"Support for the expression below:\r\n```\r\nLike HiveQL:\r\nGROUP BY expression list WITH ROLLUP\r\nGROUP BY expression list WITH CUBE\r\nGROUP BY expression list GROUPING SETS(expression list2)\r\n```\r\nand\r\n```\r\nGROUP BY ROLLUP(expression list)\r\nGROUP BY CUBE(expression list)\r\nGROUP BY GROUPING SETS(expression list)\r\n```\r\nand\r\n```\r\nGROUPING (column name)\r\n```\r\n\r\nThanks to @scwf @haiyangsea\r\n/cc @chenghao-intel @yhuai\r\n\r\nhttps://github.com/apache/spark/pull/3964"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/82679216","html_url":"https://github.com/apache/spark/pull/5045#issuecomment-82679216","issue_url":"https://api.github.com/repos/apache/spark/issues/5045","id":82679216,"user":{"login":"watermen","id":1400819,"avatar_url":"https://avatars.githubusercontent.com/u/1400819?v=3","gravatar_id":"","url":"https://api.github.com/users/watermen","html_url":"https://github.com/watermen","followers_url":"https://api.github.com/users/watermen/followers","following_url":"https://api.github.com/users/watermen/following{/other_user}","gists_url":"https://api.github.com/users/watermen/gists{/gist_id}","starred_url":"https://api.github.com/users/watermen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/watermen/subscriptions","organizations_url":"https://api.github.com/users/watermen/orgs","repos_url":"https://api.github.com/users/watermen/repos","events_url":"https://api.github.com/users/watermen/events{/privacy}","received_events_url":"https://api.github.com/users/watermen/received_events","type":"User","site_admin":false},"created_at":"2015-03-18T01:56:42Z","updated_at":"2015-03-18T01:56:42Z","body":"@yhuai I will split this patch into 2 patch, and the first patch will support the syntax that is also supported by HiveContext. Then if first patch merged, I will push the second patch which support other syntaxs in SQL99. ok?"}}