Achievement Unlocked: 12 hour Redshift Query Completepic.twitter.com/dEMnBQhXYf
You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
@avibryant window functions are a beautiful thing. took me 10 minutes to write the query, just trading human overhead for machine overhead
@fredbenenson ... good thing you got it right on the first try, I guess.
@avibryant heh. yeah, I windowed it to 1 days worth of data, confirmed, then let it rip on 2 years of data
@fredbenenson (actually I'd love to sit down with you at some point and talk about windowing functions; I want a good Scala API for them).
@avibryant I know @hadleywickham was experimenting with them for dplyr
@fredbenenson @avibryant my description/api at http://cran.r-project.org/web/packages/dplyr/vignettes/window-functions.html …. Could do a little better if didn't need existing R fun compat
@hadleywickham @avibryant this is really great Hadley. Also extra points for portraying vector recycling a feature... I jest
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.