GHive: A Demonstration of GPU-Accelerated Query Processing in Apache Hive

Liu，Haotian1; Tang，Bo1; Zhang，Jiashu1; Deng，Yangshen1; Zheng，Xinying1; Shen，Qiaomu1; Yan，Xiao1; Zeng，Dan1; Mao，Zunyao1; Zhang，Chaozu1; You，Zhengxin1; Wang，Zhihao1; Jiang，Runzhe1; Wang，Fang2; Yiu，Man Lung2; Li，Huan3; Han，Mingji4; Li，Qian1,5; Luo，Zhenghai5

10.1145/3514221.3520166

2022-06-10

0730-8078

Proceedings of the ACM SIGMOD International Conference on Management of Data

2417-2420

As a distributed, fault-tolerant data warehouse system for large-scale data analytics, Apache Hive has been used for various applications in many organizations (e.g., Facebook, Amazon, and Huawei). Exploiting the large degrees of parallelism of GPU to improve the performance of online analytical processing (OLAP) in database system is a common practice in the industry. Meanwhile, it is a common practice to exploit the large degrees of parallelism of GPU to improve the performance of online analytical processing (OLAP) in database systems. This demo presents GHive, which enables Apache Hive to accelerate OLAP queries by jointly utilizing CPU and GPU in intelligent and efficient ways. The takeaways for SIGMOD attendees include: (1) the superior performance of GHive compared with vanilla Hive that only uses CPU; (2) intuitive visualizations of execution statistics for Hive and GHive to understand where the acceleration of GHive comes from; (3) detailed profiling of the time taken by each operator on CPU and GPU to show the advantages of GPU execution.

Apache Hive CPU-GPU co-processing OLAP

第一

英语

EI

20222612274972

Data Analytics ; Data warehouses ; Graphics processing unit ; Online systems

Semiconductor Devices and Integrated Circuits:714.2 ; Computer Circuits:721.3 ; Digital Computers and Systems:722.4 ; Data Processing and Image Processing:723.2 ; Database Systems:723.3

2-s2.0-85132712826

Scopus

1.Southern University of Science and Technology,Shenzhen,China
2.Hong Kong Polytechnic University,Hong Kong,Hong Kong
3.Aalborg University,Aalborg,Denmark
4.University of Massachusetts,Amherst,United States
5.Huawei Technologies Co.,Ltd.,Shenzhen,China

Liu，Haotian,Tang，Bo,Zhang，Jiashu,et al. GHive: A Demonstration of GPU-Accelerated Query Processing in Apache Hive[C],2022:2417-2420.