If you are using Tez, you can set hive.tez.exec.print.summary=true; in CLI to see the breakdown.
From: Shirley Cohen <shirley.co...@rackspace.com<mailto:shirley.co...@rackspace.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Thursday, December 3, 2015 at 08:06 To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Subject: query execution Hi, I want to characterize the overhead for each step of a Hive query. The explain output doesn’t give me the actual execution times, so how would I find those out? Thanks in advance, Shirley