Skip to content

Instantly share code, notes, and snippets.

@seandavi
Created March 27, 2017 20:38
Show Gist options
  • Save seandavi/f8edbdb2676259b63863c7387afc6e0a to your computer and use it in GitHub Desktop.
Save seandavi/f8edbdb2676259b63863c7387afc6e0a to your computer and use it in GitHub Desktop.
bigrquery join example demonstrating error with "USING"
library(dplyr)
library(bigrquery)
db1 = src_bigquery(project = 'bigquery-public-data', dataset = 'hacker_news', billing = 'isb-cgc-04-0020')
comments = tbl(src = db1, 'full')
stories = tbl(src = db1, 'stories')
sessionInfo()
results = stories %>%
left_join(comments, by = c('url' = 'url')) %>%
head() %>% collect()
Attaching package: ‘dplyr’
The following objects are masked from ‘package:stats’:
filter, lag
The following objects are masked from ‘package:base’:
intersect, setdiff, setequal, union
R Under development (unstable) (2016-10-26 r71594)
Platform: x86_64-apple-darwin13.4.0 (64-bit)
Running under: macOS Sierra 10.12.3
locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8
attached base packages:
[1] stats graphics grDevices utils datasets base
other attached packages:
[1] bigrquery_0.3.0.9000 dplyr_0.5.0
loaded via a namespace (and not attached):
[1] httr_1.2.1 magrittr_1.5 R6_2.2.0 assertthat_0.1 tools_3.4.0
[6] DBI_0.6 curl_2.4 tibble_1.2 Rcpp_0.12.10 methods_3.4.0
[11] jsonlite_1.3 openssl_0.9.6
Error: 8.1 - 8.15: Unrecognized token Using
Execution halted
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment