{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/14897","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/14897/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/14897/comments","events_url":"https://api.github.com/repos/apache/spark/issues/14897/events","html_url":"https://github.com/apache/spark/pull/14897","id":174293868,"number":14897,"title":"[SPARK-17338][SQL] add global temp view","user":{"login":"cloud-fan","id":3182036,"avatar_url":"https://avatars.githubusercontent.com/u/3182036?v=3","gravatar_id":"","url":"https://api.github.com/users/cloud-fan","html_url":"https://github.com/cloud-fan","followers_url":"https://api.github.com/users/cloud-fan/followers","following_url":"https://api.github.com/users/cloud-fan/following{/other_user}","gists_url":"https://api.github.com/users/cloud-fan/gists{/gist_id}","starred_url":"https://api.github.com/users/cloud-fan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cloud-fan/subscriptions","organizations_url":"https://api.github.com/users/cloud-fan/orgs","repos_url":"https://api.github.com/users/cloud-fan/repos","events_url":"https://api.github.com/users/cloud-fan/events{/privacy}","received_events_url":"https://api.github.com/users/cloud-fan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-08-31T14:49:29Z","updated_at":"2016-09-01T22:54:48Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/14897","html_url":"https://github.com/apache/spark/pull/14897","diff_url":"https://github.com/apache/spark/pull/14897.diff","patch_url":"https://github.com/apache/spark/pull/14897.patch"},"body":"## What changes were proposed in this pull request?\r\n\r\nglobal temporary view is a cross-session temporary view, which means it's shared among all sessions. Its lifetime is the lifetime of the Spark application, i.e. it will be automatically dropped when the application terminates. It's not tied to any databases, i.e. we can't use `db1.view1` to reference a global temporary view.\r\n\r\n## How was this patch tested?\r\n\r\nnew tests in `SQLViewSuite`"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/244236893","html_url":"https://github.com/apache/spark/pull/14897#issuecomment-244236893","issue_url":"https://api.github.com/repos/apache/spark/issues/14897","id":244236893,"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},"created_at":"2016-09-01T22:54:48Z","updated_at":"2016-09-01T22:54:48Z","body":"How about another API `refreshTable`? We allow users to refresh it for local temporary tables.\r\nhttps://github.com/apache/spark/blob/f7c9ff57c17a950cccdc26aadf8768c899a4d572/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/catalog/SessionCatalog.scala#L491-L498"}}
{"actor":{"display_login":"gatorsmile"}}