{"action":"created","issue":{"url":"https://api.github.com/repos/hadley/bigrquery/issues/62","labels_url":"https://api.github.com/repos/hadley/bigrquery/issues/62/labels{/name}","comments_url":"https://api.github.com/repos/hadley/bigrquery/issues/62/comments","events_url":"https://api.github.com/repos/hadley/bigrquery/issues/62/events","html_url":"https://github.com/hadley/bigrquery/issues/62","id":119597790,"number":62,"title":"Unable to append data through query_exec","user":{"login":"3vivekb","id":4524205,"avatar_url":"https://avatars.githubusercontent.com/u/4524205?v=3","gravatar_id":"","url":"https://api.github.com/users/3vivekb","html_url":"https://github.com/3vivekb","followers_url":"https://api.github.com/users/3vivekb/followers","following_url":"https://api.github.com/users/3vivekb/following{/other_user}","gists_url":"https://api.github.com/users/3vivekb/gists{/gist_id}","starred_url":"https://api.github.com/users/3vivekb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/3vivekb/subscriptions","organizations_url":"https://api.github.com/users/3vivekb/orgs","repos_url":"https://api.github.com/users/3vivekb/repos","events_url":"https://api.github.com/users/3vivekb/events{/privacy}","received_events_url":"https://api.github.com/users/3vivekb/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-30T22:40:06Z","updated_at":"2015-12-01T19:49:06Z","closed_at":null,"body":"I want to perform a query and grab a large amount of data from one table, then add it to another table that already contains data using R.\r\n\r\nSo if I select a table that already exists I get \"Error: Already Exists: Table ic...\"\r\n\r\nIn Bigquery what is happpening is we are \r\n1. Selecting a destination table\r\n2. Writing if empty\r\nWhile using the Bigquery Web console we can \r\n1. Selecting a destination table\r\n2. Append to a table\r\n\r\nCan we add this functionality to bigrquery's query_exec?  Is it available in the BigQuery API?  I imagine it gets complicated when the tables are different."},"comment":{"url":"https://api.github.com/repos/hadley/bigrquery/issues/comments/161075965","html_url":"https://github.com/hadley/bigrquery/issues/62#issuecomment-161075965","issue_url":"https://api.github.com/repos/hadley/bigrquery/issues/62","id":161075965,"user":{"login":"craigcitro","id":468559,"avatar_url":"https://avatars.githubusercontent.com/u/468559?v=3","gravatar_id":"","url":"https://api.github.com/users/craigcitro","html_url":"https://github.com/craigcitro","followers_url":"https://api.github.com/users/craigcitro/followers","following_url":"https://api.github.com/users/craigcitro/following{/other_user}","gists_url":"https://api.github.com/users/craigcitro/gists{/gist_id}","starred_url":"https://api.github.com/users/craigcitro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/craigcitro/subscriptions","organizations_url":"https://api.github.com/users/craigcitro/orgs","repos_url":"https://api.github.com/users/craigcitro/repos","events_url":"https://api.github.com/users/craigcitro/events{/privacy}","received_events_url":"https://api.github.com/users/craigcitro/received_events","type":"User","site_admin":false},"created_at":"2015-12-01T19:49:06Z","updated_at":"2015-12-01T19:49:06Z","body":"sure -- that's just a call to `insert_query_job`, right?"}}