hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gopal Vijayaraghavan <gop...@apache.org>
Subject Re: Experimental results using TPC-DS (versus Spark and Presto)
Date Mon, 30 Jan 2017 11:24:31 GMT

> Hive LLAP shows better performance than Presto and Spark for most queries, but it shows
very poor performance on the execution of query 72.

My suspicion will be the the inventory x catalog_sales x warehouse join - assuming the column
statistics are present and valid.

If you could send the explain formatted plans and swimlanes for LLAP, I can probably debug
this better.

https://github.com/apache/tez/blob/master/tez-tools/swimlanes/yarn-swimlanes.sh

Use the "submitted to <appid>" in this to get the diagram.

Cheers,
Gopal



Mime
View raw message