Is it demented to take pleasure when I can manage to make Redshift sweat?
-
-
Replying to @fredbenenson
@fredbenenson any chance you're using redshift from R? I'm looking to make the experience smoother, but I don't have any big enough data2 replies 0 retweets 1 like -
Replying to @hadleywickham
@hadleywickham@fredbenenson same here guys. We use Redshift and R at SoundCloud as the main workflow for data analysis. Happy to chat.3 replies 0 retweets 0 likes -
Replying to @lftherios
@eled22@fredbenenson i.e. what sql are you running? I think switching between SQL & R has high cognitive cost1 reply 0 retweets 1 like -
Replying to @hadleywickham
@hadleywickham One example might be: show me the most popular amount pledged per month: https://gist.github.com/fredbenenson/7566727 …1 reply 0 retweets 0 likes -
Replying to @fredbenenson
@fredbenenson why use sum(1) and not rownumber() window function?2 replies 0 retweets 0 likes -
Replying to @hadleywickham
@hadleywickham Redshift doesn't support ROWNUM() yet2 replies 0 retweets 0 likes -
Replying to @fredbenenson
@fredbenenson also seems like bigquery's top would help: https://developers.google.com/bigquery/query-reference#top-function …1 reply 0 retweets 0 likes -
Replying to @hadleywickham
@hadleywickham ooh, yeah, TOP seems cool -- curious what they're doing under the hood to make it perform better2 replies 0 retweets 0 likes
@fredbenenson @hadleywickham they mention it's approximate, so it'll be something like SpaceSaver or Count-min sketch.
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.