{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/13209","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/13209/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/13209/comments","events_url":"https://api.github.com/repos/apache/spark/issues/13209/events","html_url":"https://github.com/apache/spark/pull/13209","id":155873376,"number":13209,"title":"[SPARK-15425][SQL] Disallow cross joins by default","user":{"login":"sameeragarwal","id":166454,"avatar_url":"https://avatars.githubusercontent.com/u/166454?v=3","gravatar_id":"","url":"https://api.github.com/users/sameeragarwal","html_url":"https://github.com/sameeragarwal","followers_url":"https://api.github.com/users/sameeragarwal/followers","following_url":"https://api.github.com/users/sameeragarwal/following{/other_user}","gists_url":"https://api.github.com/users/sameeragarwal/gists{/gist_id}","starred_url":"https://api.github.com/users/sameeragarwal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sameeragarwal/subscriptions","organizations_url":"https://api.github.com/users/sameeragarwal/orgs","repos_url":"https://api.github.com/users/sameeragarwal/repos","events_url":"https://api.github.com/users/sameeragarwal/events{/privacy}","received_events_url":"https://api.github.com/users/sameeragarwal/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2016-05-20T02:10:23Z","updated_at":"2016-05-23T04:54:50Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/13209","html_url":"https://github.com/apache/spark/pull/13209","diff_url":"https://github.com/apache/spark/pull/13209.diff","patch_url":"https://github.com/apache/spark/pull/13209.patch"},"body":"## What changes were proposed in this pull request?\r\n\r\nIn order to prevent users from inadvertently writing queries with cartesian joins, this patch introduces a new conf `spark.sql.crossJoin.enabled` (set to `false` by default) that if not set, results in a `SparkException` if the query contains one or more cartesian products.\r\n\r\n## How was this patch tested?\r\n\r\nAdded a test to verify the new behavior in `JoinSuite`. Additionally, `SQLQuerySuite` and `SQLMetricsSuite` were modified to explicitly enable cartesian products.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/220887288","html_url":"https://github.com/apache/spark/pull/13209#issuecomment-220887288","issue_url":"https://api.github.com/repos/apache/spark/issues/13209","id":220887288,"user":{"login":"sameeragarwal","id":166454,"avatar_url":"https://avatars.githubusercontent.com/u/166454?v=3","gravatar_id":"","url":"https://api.github.com/users/sameeragarwal","html_url":"https://github.com/sameeragarwal","followers_url":"https://api.github.com/users/sameeragarwal/followers","following_url":"https://api.github.com/users/sameeragarwal/following{/other_user}","gists_url":"https://api.github.com/users/sameeragarwal/gists{/gist_id}","starred_url":"https://api.github.com/users/sameeragarwal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sameeragarwal/subscriptions","organizations_url":"https://api.github.com/users/sameeragarwal/orgs","repos_url":"https://api.github.com/users/sameeragarwal/repos","events_url":"https://api.github.com/users/sameeragarwal/events{/privacy}","received_events_url":"https://api.github.com/users/sameeragarwal/received_events","type":"User","site_admin":false},"created_at":"2016-05-23T04:54:50Z","updated_at":"2016-05-23T04:54:50Z","body":"test this please"}}
{"actor":{"display_login":"sameeragarwal"}}