DeFiHap: Detecting and Fixing HiveQL Anti-Patterns

Summary: Empirical study identifies 38 HiveQL anti-patterns and their impact on performance. DeFiHap automates detection and repair via AST-based analysis and rule-based rewriting with perf-tuning; it detects 25 anti-patterns and suggests fixes for 17. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 12442
Venue: VLDB
Year: 2021
Pagerank: 4.1945683e-05
Overall Rank: 11,508 | 19.95%
DOI: 10.14778/3476311.3476316

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 1 of 1 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
3,409	SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns	2020	SIGMOD	7.1270252e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,891	APOLLO: Automatic Detection and Diagnosis of Performance Regressions in Database Systems	2020	VLDB	7.954658e-05
11,837	QFix: Demonstrating Error Diagnosis in Query Histories	2016	SIGMOD	4.1945683e-05
10,568	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1945683e-05
70	Hive - A Warehousing Solution Over a Map-Reduce Framework	2009	VLDB	0.00059533166
12,028	D-Hive: Data Bees Pollinating RDF, Text, and Time	2013	CIDR	4.1945683e-05
5,445	QFix: Diagnosing Errors through Query Histories	2017	SIGMOD	5.5020909e-05
11,517	Interactive Demonstration of SQLCheck	2021	VLDB	4.1945683e-05
8,924	QMapper for Smart Grid: Migrating SQL-based Application to Hive	2015	SIGMOD	4.427232e-05
11,286	DHive: Query Execution Performance Analysis via Dataflow in Apache Hive	2023	VLDB	4.1945683e-05
3,409	SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns	2020	SIGMOD	7.1270252e-05