Hello, Just from my personal testing, Hive 3.1.3 has much better performance than the old ones. It's even as fast as Spark by using the default mr engine. My test process and dataset, https://blog.crypt.pw/Another-10-million-dataset-testing-for-Spark-and-Hive
Thanks.