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: 12443
Venue: VLDB
Year: 2021
Pagerank: 5.1725247e-05
Overall Rank: 11,512 | 20.00%
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
4,211	SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns	2020	SIGMOD	6.8931007e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,332	APOLLO: Automatic Detection and Diagnosis of Performance Regressions in Database Systems	2020	VLDB	8.8193868e-05
11,845	QFix: Demonstrating Error Diagnosis in Query Histories	2016	SIGMOD	5.1725247e-05
10,577	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	5.1725247e-05
33	Hive - A Warehousing Solution Over a Map-Reduce Framework	2009	VLDB	0.00050623146
12,036	D-Hive: Data Bees Pollinating RDF, Text, and Time	2013	CIDR	5.1725247e-05
4,892	QFix: Diagnosing Errors through Query Histories	2017	SIGMOD	6.5234004e-05
11,521	Interactive Demonstration of SQLCheck	2021	VLDB	5.1725247e-05
8,951	QMapper for Smart Grid: Migrating SQL-based Application to Hive	2015	SIGMOD	5.4076395e-05
11,288	DHive: Query Execution Performance Analysis via Dataflow in Apache Hive	2023	VLDB	5.1725247e-05
4,211	SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns	2020	SIGMOD	6.8931007e-05