SQL-on-Hadoop: Full Circle Back to Shared-Nothing Database Architectures

Summary: Comparing Hive (MapReduce/Tez) and Impala in a shared-nothing SQL-on-Hadoop setting, using ORC/Parquet and TPC-H/TPC-DS workloads with micro-bench I/O. Impala wins: 3.3–4.4x on MR, 2.1–2.8x on Tez for TPC-H; 8.2–10x MR and ~4x Tez for TPC-DS, with analysis of causes, strengths, and limitations. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10790
Venue: VLDB
Year: 2014
Pagerank: 9.4836925e-05
Overall Rank: 2,123 | 85.25%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 14 of 14 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
476	Impala: A Modern, Open-Source SQL Engine for Hadoop	2015	CIDR	0.00022216002
486	TiDB: A Raft-based HTAP Database	2020	VLDB	0.00022039625
1,260	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00012990853
1,397	High-Speed Query Processing over High-Speed Networks	2016	VLDB	0.00012208385
4,516	An Empirical Evaluation of Columnar Storage Formats	2024	VLDB	6.1146215e-05
5,571	A Deep Dive into Common Open Formats for Analytical DBMSs	2023	VLDB	5.4279553e-05
6,257	VectorH: Taking SQL-on-Hadoop to the Next Level	2016	SIGMOD	5.1316025e-05
6,301	Elastic Pipelining in an In-Memory Database Cluster	2016	SIGMOD	5.1172165e-05
7,079	JetScope: Reliable and Interactive Analytics at Cloud Scale	2015	VLDB	4.8353804e-05
8,444	Adaptive Compression for Fast Scans on String Columns	2021	SIGMOD	4.5043421e-05
8,625	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	4.4784651e-05
8,927	QMapper for Smart Grid: Migrating SQL-based Application to Hive	2015	SIGMOD	4.4229886e-05
10,808	GraphAr: An Efficient Storage Scheme for Graph Data in Data Lakes	2025	VLDB	4.1905499e-05
13,238	Reflections On My Data Management Research Journey (VLDB Women in Database Research Award Talk)	2022	VLDB	-

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
20	C-Store: A Column-oriented DBMS	2005	VLDB	0.00086163998
109	Dremel: Interactive Analysis of Web-Scale Datasets	2010	VLDB	0.00048217028
158	HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads	2009	VLDB	0.00040401371
539	Shark: SQL and Rich Analytics at Scale	2013	SIGMOD	0.00020615453
1,590	Column-oriented Database Systems	2009	VLDB	0.00011230525
1,980	Split Query Processing in Polybase	2013	SIGMOD	9.8740305e-05
3,070	HAWQ: A Massively Parallel Processing SQL Engine in Hadoop	2014	SIGMOD	7.6157391e-05
3,193	Column-Oriented Storage Techniques for MapReduce	2011	VLDB	7.4073719e-05
3,244	Can the Elephants Handle the NoSQL Onslaught?	2012	VLDB	7.3247981e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,070	HAWQ: A Massively Parallel Processing SQL Engine in Hadoop	2014	SIGMOD	7.6157391e-05
11,695	Integration of Large-Scale Data Processing Systems and Traditional Parallel Database Technology	2019	VLDB	4.1905499e-05
789	Hadoop++: Making a Yellow Elephant Run Like a Cheetah (Without It Even Noticing)	2010	VLDB	0.00016602215
7,269	Oracle In-Database Hadoop: When MapReduce Meets RDBMS	2012	SIGMOD	4.7768528e-05
3,966	Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing	2019	SIGMOD	6.5782437e-05
158	HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads	2009	VLDB	0.00040401371
2,998	Major Technical Advancements in Apache Hive	2014	SIGMOD	7.7477264e-05
2,340	Efficient Processing of Data Warehousing Queries in a Split Execution Environment	2011	SIGMOD	9.001663e-05
11,956	Tutorial: SQL-on-Hadoop Systems	2015	VLDB	4.1905499e-05
476	Impala: A Modern, Open-Source SQL Engine for Hadoop	2015	CIDR	0.00022216002