> 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


Reply via email to