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: 10977
Venue: VLDB
Year: 2014
Pagerank: 9.5335988e-05
Overall Rank: 1,889 | 87.05%
DOI: 10.14778/2732977.2733002

Incoming Non-self Citations Over Time

Authors

1. Avrilia Floratou (IBM)
2. Umar Farooq Minhas (IBM)
3. Fatma Özcan (IBM)

BibTeX Citation

@article{floratou_vldb14,
        title = {{SQL-on-Hadoop: Full Circle Back to Shared-Nothing Database Architectures}},
        author = {Floratou, Avrilia and Minhas, Umar Farooq and Özcan, Fatma},
        journal = {PVLDB},
        series = {{VLDB} '14},
        volume = {7},
        number = {12},
        pages = {1295--1306},
        doi = {10.14778/2732977.2733002},
        url = {https://doi.org/10.14778/2732977.2733002},
        year = {2014}
}

Incoming Citations (Sorted by Pagerank)

Showing 14 of 14 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
271	TiDB: A Raft-based HTAP Database	2020	VLDB	0.00022703024
330	Impala: A Modern, Open-Source SQL Engine for Hadoop	2015	CIDR	0.0002104801
941	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00013078348
1,076	High-Speed Query Processing over High-Speed Networks	2016	VLDB	0.00012270109
3,877	An Empirical Evaluation of Columnar Storage Formats	2024	VLDB	7.0532293e-05
5,037	A Deep Dive into Common Open Formats for Analytical DBMSs	2023	VLDB	6.3914026e-05
6,103	VectorH: Taking SQL-on-Hadoop to the Next Level	2016	SIGMOD	5.9755412e-05
6,255	Elastic Pipelining in an In-Memory Database Cluster	2016	SIGMOD	5.9399698e-05
6,822	JetScope: Reliable and Interactive Analytics at Cloud Scale	2015	VLDB	5.7627651e-05
8,436	Adaptive Compression for Fast Scans on String Columns	2021	SIGMOD	5.4253644e-05
8,465	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	5.4194578e-05
9,079	QMapper for Smart Grid: Migrating SQL-based Application to Hive	2015	SIGMOD	5.3251649e-05
11,030	GraphAr: An Efficient Storage Scheme for Graph Data in Data Lakes	2025	VLDB	5.093636e-05
13,428	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
12	C-Store: A Column-oriented DBMS	2005	VLDB	0.00069513174
51	Dremel: Interactive Analysis of Web-Scale Datasets	2010	VLDB	0.0004291425
120	HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads	2009	VLDB	0.00031680027
425	Shark: SQL and Rich Analytics at Scale	2013	SIGMOD	0.00018704491
1,395	Column-oriented Database Systems	2009	VLDB	0.00010928358
1,739	Split Query Processing in Polybase	2013	SIGMOD	9.8814935e-05
2,849	Column-Oriented Storage Techniques for MapReduce	2011	VLDB	8.053191e-05
2,850	HAWQ: A Massively Parallel Processing SQL Engine in Hadoop	2014	SIGMOD	8.0499212e-05
4,230	Can the Elephants Handle the NoSQL Onslaught?	2012	VLDB	6.8178353e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,850	HAWQ: A Massively Parallel Processing SQL Engine in Hadoop	2014	SIGMOD
2	11,885	Integration of Large-Scale Data Processing Systems and Traditional Parallel Database Technology	2019	VLDB
3	660	Hadoop++: Making a Yellow Elephant Run Like a Cheetah (Without It Even Noticing)	2010	VLDB
4	7,689	Oracle In-Database Hadoop: When MapReduce Meets RDBMS	2012	SIGMOD
5	3,555	Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing	2019	SIGMOD
6	120	HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads	2009	VLDB
7	2,706	Major Technical Advancements in Apache Hive	2014	SIGMOD
8	2,159	Efficient Processing of Data Warehousing Queries in a Split Execution Environment	2011	SIGMOD
9	12,146	Tutorial: SQL-on-Hadoop Systems	2015	VLDB
10	330	Impala: A Modern, Open-Source SQL Engine for Hadoop	2015	CIDR