{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/20433","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/20433/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/20433/comments","events_url":"https://api.github.com/repos/apache/spark/issues/20433/events","html_url":"https://github.com/apache/spark/pull/20433","id":292666486,"node_id":"MDExOlB1bGxSZXF1ZXN0MTY1ODk1ODE5","number":20433,"title":"[SPARK-23264][SQL] Make INTERVAL keyword optional in INTERVAL clauses","user":{"login":"maropu","id":692303,"node_id":"MDQ6VXNlcjY5MjMwMw==","avatar_url":"https://avatars3.githubusercontent.com/u/692303?v=4","gravatar_id":"","url":"https://api.github.com/users/maropu","html_url":"https://github.com/maropu","followers_url":"https://api.github.com/users/maropu/followers","following_url":"https://api.github.com/users/maropu/following{/other_user}","gists_url":"https://api.github.com/users/maropu/gists{/gist_id}","starred_url":"https://api.github.com/users/maropu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maropu/subscriptions","organizations_url":"https://api.github.com/users/maropu/orgs","repos_url":"https://api.github.com/users/maropu/repos","events_url":"https://api.github.com/users/maropu/events{/privacy}","received_events_url":"https://api.github.com/users/maropu/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":41,"created_at":"2018-01-30T06:25:23Z","updated_at":"2018-10-04T01:33:02Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/20433","html_url":"https://github.com/apache/spark/pull/20433","diff_url":"https://github.com/apache/spark/pull/20433.diff","patch_url":"https://github.com/apache/spark/pull/20433.patch"},"body":"## What changes were proposed in this pull request?\r\nThis pr updated parsing rules in `SqlBase.g4` to support a SQL query below;\r\n```\r\nSELECT CAST('2017-08-04' AS DATE) + 1 days;\r\n```\r\nThe current master cannot parse it though, other dbms-like systems support the syntax (e.g., hive and mysql). Also, the syntax is frequently used in the official TPC-DS queries.\r\n\r\n## How was this patch tested?\r\nAdded tests in `SQLQuerySuite`.\r\n"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/426856525","html_url":"https://github.com/apache/spark/pull/20433#issuecomment-426856525","issue_url":"https://api.github.com/repos/apache/spark/issues/20433","id":426856525,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNjg1NjUyNQ==","user":{"login":"AmplabJenkins","id":4031291,"node_id":"MDQ6VXNlcjQwMzEyOTE=","avatar_url":"https://avatars3.githubusercontent.com/u/4031291?v=4","gravatar_id":"","url":"https://api.github.com/users/AmplabJenkins","html_url":"https://github.com/AmplabJenkins","followers_url":"https://api.github.com/users/AmplabJenkins/followers","following_url":"https://api.github.com/users/AmplabJenkins/following{/other_user}","gists_url":"https://api.github.com/users/AmplabJenkins/gists{/gist_id}","starred_url":"https://api.github.com/users/AmplabJenkins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AmplabJenkins/subscriptions","organizations_url":"https://api.github.com/users/AmplabJenkins/orgs","repos_url":"https://api.github.com/users/AmplabJenkins/repos","events_url":"https://api.github.com/users/AmplabJenkins/events{/privacy}","received_events_url":"https://api.github.com/users/AmplabJenkins/received_events","type":"User","site_admin":false},"created_at":"2018-10-04T01:33:02Z","updated_at":"2018-10-04T01:33:02Z","author_association":"NONE","body":"Test PASSed.\nRefer to this link for build results (access rights to CI server needed): \nhttps://amplab.cs.berkeley.edu/jenkins//job/testing-k8s-prb-make-spark-distribution-unified/3667/\nTest PASSed."}}
{"actor":{"display_login":"AmplabJenkins"}}