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: hf83fdd87c379c461
Venue: VLDB
Year: 2014
Pagerank: 9.4388097e-05
Overall Rank: 1,884 | 87.34%
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
234	TiDB: A Raft-based HTAP Database	2020	VLDB	0.00023765806
327	Impala: A Modern, Open-Source SQL Engine for Hadoop	2015	CIDR	0.0002095191
906	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00013160654
1,028	High-Speed Query Processing over High-Speed Networks	2016	VLDB	0.00012422084
3,808	An Empirical Evaluation of Columnar Storage Formats	2024	VLDB	7.0097354e-05
4,635	A Deep Dive into Common Open Formats for Analytical DBMSs	2023	VLDB	6.4932705e-05
5,817	VectorH: Taking SQL-on-Hadoop to the Next Level	2016	SIGMOD	5.9840356e-05
6,288	Elastic Pipelining in an In-Memory Database Cluster	2016	SIGMOD	5.8227911e-05
6,958	JetScope: Reliable and Interactive Analytics at Cloud Scale	2015	VLDB	5.634024e-05
8,153	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	5.3891786e-05
8,608	Adaptive Compression for Fast Scans on String Columns	2021	SIGMOD	5.3036338e-05
9,254	QMapper for Smart Grid: Migrating SQL-based Application to Hive	2015	SIGMOD	5.2056825e-05
11,394	GraphAr: An Efficient Storage Scheme for Graph Data in Data Lakes	2025	VLDB	4.9793485e-05
13,742	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.00068998927
49	Dremel: Interactive Analysis of Web-Scale Datasets	2010	VLDB	0.00043160717
120	HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads	2009	VLDB	0.000311132
432	Shark: SQL and Rich Analytics at Scale	2013	SIGMOD	0.00018339357
1,327	Column-oriented Database Systems	2009	VLDB	0.00011003776
1,751	Split Query Processing in Polybase	2013	SIGMOD	9.7291888e-05
2,898	HAWQ: A Massively Parallel Processing SQL Engine in Hadoop	2014	SIGMOD	7.8853204e-05
2,903	Column-Oriented Storage Techniques for MapReduce	2011	VLDB	7.8810111e-05
4,289	Can the Elephants Handle the NoSQL Onslaught?	2012	VLDB	6.6838669e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,898	HAWQ: A Massively Parallel Processing SQL Engine in Hadoop	2014	SIGMOD
2	12,185	Integration of Large-Scale Data Processing Systems and Traditional Parallel Database Technology	2019	VLDB
3	673	Hadoop++: Making a Yellow Elephant Run Like a Cheetah (Without It Even Noticing)	2010	VLDB
4	7,843	Oracle In-Database Hadoop: When MapReduce Meets RDBMS	2012	SIGMOD
5	3,446	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,689	Major Technical Advancements in Apache Hive	2014	SIGMOD
8	2,173	Efficient Processing of Data Warehousing Queries in a Split Execution Environment	2011	SIGMOD
9	12,438	Tutorial: SQL-on-Hadoop Systems	2015	VLDB
10	327	Impala: A Modern, Open-Source SQL Engine for Hadoop	2015	CIDR