https://community.cloudera.com/t5/Archives-of-Support-Questions/Number-of-MapReduce-jobs-for-single-Hive-query/m-p/38007#M16700 You can run an EXPLAIN on a query to see how Hive would plan to run the query (how many phases). This will help you get a sense of 'how many jobs' or something close to it.<BR /><BR />Your query is invalid in HiveQL, but with GROUP BY statements further added for col1 and col2 to make it legal, it would take a single job. Sun, 28 Feb 2016 09:58:45 GMT Harsh J 2016-02-28T09:58:45Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Number-of-MapReduce-jobs-for-single-Hive-query/m-p/36770#M16699 <P>Hi,</P><P>&nbsp;</P><P>How to find out the number of MapReduce jobs for single Hive query?</P><P>Could you please let me know if I execute below query how many mapreduce jobs will be launched and the squence of these jobs.</P><P>&nbsp;</P><P>select col1, col2, sum(col3), count(col4), avg(col5) from sample_table where col1=condition;</P><P>&nbsp;</P><P>Thanks in advance</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 16 Sep 2022 10:00:39 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Number-of-MapReduce-jobs-for-single-Hive-query/m-p/36770#M16699 Anishsk10 2022-09-16T10:00:39Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Number-of-MapReduce-jobs-for-single-Hive-query/m-p/38007#M16700 You can run an EXPLAIN on a query to see how Hive would plan to run the query (how many phases). This will help you get a sense of 'how many jobs' or something close to it.<BR /><BR />Your query is invalid in HiveQL, but with GROUP BY statements further added for col1 and col2 to make it legal, it would take a single job. Sun, 28 Feb 2016 09:58:45 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Number-of-MapReduce-jobs-for-single-Hive-query/m-p/38007#M16700 Harsh J 2016-02-28T09:58:45Z