{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/14746","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/14746/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/14746/comments","events_url":"https://api.github.com/repos/apache/spark/issues/14746/events","html_url":"https://github.com/apache/spark/pull/14746","id":172381060,"number":14746,"title":"[SPARK-17180] [SQL] Fix View Resolution Order in ALTER VIEW AS SELECT","user":{"login":"gatorsmile","id":11567269,"avatar_url":"https://avatars.githubusercontent.com/u/11567269?v=3","gravatar_id":"","url":"https://api.github.com/users/gatorsmile","html_url":"https://github.com/gatorsmile","followers_url":"https://api.github.com/users/gatorsmile/followers","following_url":"https://api.github.com/users/gatorsmile/following{/other_user}","gists_url":"https://api.github.com/users/gatorsmile/gists{/gist_id}","starred_url":"https://api.github.com/users/gatorsmile/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gatorsmile/subscriptions","organizations_url":"https://api.github.com/users/gatorsmile/orgs","repos_url":"https://api.github.com/users/gatorsmile/repos","events_url":"https://api.github.com/users/gatorsmile/events{/privacy}","received_events_url":"https://api.github.com/users/gatorsmile/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2016-08-22T06:54:20Z","updated_at":"2016-08-28T08:35:48Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/14746","html_url":"https://github.com/apache/spark/pull/14746","diff_url":"https://github.com/apache/spark/pull/14746.diff","patch_url":"https://github.com/apache/spark/pull/14746.patch"},"body":"### What changes were proposed in this pull request?\r\nIn the current master branch, when users do not specify the database name in the `ALTER VIEW AS SELECT` command, we always try to alter the permanent view even if the temporary view exists. This PR is to resolve this issue. \r\n\r\nAfter the fix, `ALTER VIEW AS SELECT` command alters the temporary view if the temp view exists; otherwise, try to alter the permanent view. This order is consistent with another command `DROP VIEW`, since users are unable to specify the keyword TEMPORARY.\r\n\r\n### How was this patch tested?\r\nAdded test cases."},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/242963201","html_url":"https://github.com/apache/spark/pull/14746#issuecomment-242963201","issue_url":"https://api.github.com/repos/apache/spark/issues/14746","id":242963201,"user":{"login":"AmplabJenkins","id":4031291,"avatar_url":"https://avatars.githubusercontent.com/u/4031291?v=3","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":"2016-08-28T08:35:48Z","updated_at":"2016-08-28T08:35:48Z","body":"Merged build finished. Test PASSed."}}
{"actor":{"display_login":"AmplabJenkins"}}