# MapReduce in terms of SQL I found a great explanation of MapReduce in terms of SQL in [a blog post about Hadoop](https://www.chrisstucchio.com/blog/2013/hadoop_hatred.html) by Chris Stucchio: > SQL-ish pseudocode: > > ```sql > SELECT G(...) FROM table GROUP BY F(...) > ``` > [...] > > The only thing you are permitted to touch is `F(k,v)` and `G(k,v)`, except of course for performance optimizations (usually not the fun kind!) at intermediate steps. Everything else is fixed. ## Page metadata URL: Published 2015-02-20, updated 2023-11-13. Tags: - algorithm - data - old blog - programming - SQL Index: [Old blog](/old-blog).