By "large", I mean in the range of 100m to 10b rows.
I'm currently using both Hadoop MapReduce and Amazon RedShift. MapReduce has been a little disappointing here. Redshift works very well if the data is distributed well for the given query.
Are there other technologies that I should be looking at here? If so, what are the trade offs?