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 tri-gram event chaining using the LEAD(…) window function across a table with billions of rows
@fredbenenson awed and a little sickened that you're doing this in SQL. Learn you some Scalding, son. ;)
@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
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.