Advances, Systems and Applications
Table 4 Execution times of sequential and merged query sets (8 and 9) in seconds
From: Improving the performance of Hadoop Hive by sharing scan and computation tasks
Query name | # of submitted queries | Execution time (sec.) Hive/SharedHive (reduction %) | ||
|---|---|---|---|---|
| Â | Â | 1GB | 100GB | 1TB |
Q1 (set 8) | 2 | 123/70 (44.9%) | 756/430 (43.1%) | 6,833/3,843 (43.8%) |
| Â | 4 | 227/77 (66.1%) | 1,435/442 (69.2%) | 13,365/3,928 (70.6%) |
| Â | 8 | 444/79 (82.2%) | 2,894/458 (84.2%) | 26,716/3,985 (85.1%) |
Q3 (set 9) | 2 | 246/176 (28.5%) | 1,334/999 (25.1%) | 15,546/14,316 (7.9%) |
| Â | 4 | 470/307 (34.7%) | 2,626/1,333 (49.2%) | 27,712/14,645 (47.2%) |
| Â | 8 | 957/503 (47.4%) | 5,486/1,466 (73.3%) | 56,112/15,615 (72.2%) |