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: 10789
Venue: VLDB
Year: 2014
Pagerank: 9.4863172e-05
Overall Rank: 2,127 | 85.21%
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.00022226941
488	TiDB: A Raft-based HTAP Database	2020	VLDB	0.000220409
1,263	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00012982857
1,409	High-Speed Query Processing over High-Speed Networks	2016	VLDB	0.00012132768
4,514	An Empirical Evaluation of Columnar Storage Formats	2024	VLDB	6.1204636e-05
5,562	A Deep Dive into Common Open Formats for Analytical DBMSs	2023	VLDB	5.4331334e-05
6,264	VectorH: Taking SQL-on-Hadoop to the Next Level	2016	SIGMOD	5.1348427e-05
6,304	Elastic Pipelining in an In-Memory Database Cluster	2016	SIGMOD	5.1210182e-05
7,067	JetScope: Reliable and Interactive Analytics at Cloud Scale	2015	VLDB	4.8440936e-05
8,487	Adaptive Compression for Fast Scans on String Columns	2021	SIGMOD	4.4999394e-05
8,645	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	4.4772518e-05
8,924	QMapper for Smart Grid: Migrating SQL-based Application to Hive	2015	SIGMOD	4.427232e-05
10,803	GraphAr: An Efficient Storage Scheme for Graph Data in Data Lakes	2025	VLDB	4.1945683e-05
13,225	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
21	C-Store: A Column-oriented DBMS	2005	VLDB	0.00086087497
109	Dremel: Interactive Analysis of Web-Scale Datasets	2010	VLDB	0.00048186983
157	HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads	2009	VLDB	0.00040397359
542	Shark: SQL and Rich Analytics at Scale	2013	SIGMOD	0.00020595648
1,590	Column-oriented Database Systems	2009	VLDB	0.00011233838
1,977	Split Query Processing in Polybase	2013	SIGMOD	9.8824589e-05
3,066	HAWQ: A Massively Parallel Processing SQL Engine in Hadoop	2014	SIGMOD	7.6221974e-05
3,208	Column-Oriented Storage Techniques for MapReduce	2011	VLDB	7.3781897e-05
3,247	Can the Elephants Handle the NoSQL Onslaught?	2012	VLDB	7.3260831e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,066	HAWQ: A Massively Parallel Processing SQL Engine in Hadoop	2014	SIGMOD	7.6221974e-05
11,690	Integration of Large-Scale Data Processing Systems and Traditional Parallel Database Technology	2019	VLDB	4.1945683e-05
794	Hadoop++: Making a Yellow Elephant Run Like a Cheetah (Without It Even Noticing)	2010	VLDB	0.00016605103
7,270	Oracle In-Database Hadoop: When MapReduce Meets RDBMS	2012	SIGMOD	4.7813984e-05
3,973	Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing	2019	SIGMOD	6.5758017e-05
157	HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads	2009	VLDB	0.00040397359
2,998	Major Technical Advancements in Apache Hive	2014	SIGMOD	7.753765e-05
2,337	Efficient Processing of Data Warehousing Queries in a Split Execution Environment	2011	SIGMOD	9.0098186e-05
11,948	Tutorial: SQL-on-Hadoop Systems	2015	VLDB	4.1945683e-05
476	Impala: A Modern, Open-Source SQL Engine for Hadoop	2015	CIDR	0.00022226941