© Scott Shaw, Andreas Francois Vermeulen, Ankur Gupta, David Kjerrumgaard 2016

Scott Shaw, Andreas François Vermeulen, Ankur Gupta and David Kjerrumgaard, Practical Hive, 10.1007/978-1-4842-0271-5_9

9. Performance Tuning: Hive

Scott Shaw, Andreas François Vermeulen2, Ankur Gupta3 and David Kjerrumgaard4

(1)Saint Louis, Missouri, USA

(2)West Kilbride North Ayrshire, UK

(3)Uxbridge, UK

(4)Henderson, Nevada, USA

One of the biggest challenges Hive users face is the slow response time experienced by end users who are running ad hoc queries. When compared to the performance achieved by traditional relation database queries, Hive’s response times are often unacceptably slow and often leave you wondering how you can achieve the type of performance your end ...

Get Practical Hive: A Guide to Hadoop's Data Warehouse System now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.