How to validate hive.exec.parallel is working

[#1]

Hello,

I am trying to use hive.exec.parallel functionality by configuring 

set hive.exec.parallel=true;

hive.exec.parallel.thread.number=8;

as suggested on support portal case

https://cloudera-portal.force.com/5003400000rBeMZ 

After configurations are made, when I run query to test I did not observe two stages running parallel and execution time is not changed compared to execution with out parallel except parallel in info for stage-5 and stage-1 ( INFO : Starting task [Stage-5:CONDITIONAL] in parallel  INFO : Starting task [Stage-1:MAPRED] in parallel)

below is my test case

CREATE TABLE  wbrp_wbrk_join_parallel_test2
TBLPROPERTIES('serialization.null.format'='')
AS
SELECT TWBRK.LIFRE AS VND_NBR_SAP
,TWBRP.WBELNV AS PONBR
,TWBRK.KUNRE AS STRNBR
,TWBRK.XBLNR AS INVNBR
,TWBRK.XBLNR AS SRTINVNBR
,TWBRK.BLDAT AS INVDT
,cast(TWBRK.BRTWR as decimal(21,2)) AS INV_AMT
,cast(TWBRK.MWSBK as decimal(21,2)) AS TAX_AMT
,TWBRK.NETWR AS PRODUCT
,TWBRP.ARKTX AS ARKTX
FROM
(select LIFRE, KUNRE, XBLNR, BLDAT, BRTWR, MWSBK, NETWR, WBELN from wbrk where condtion....) TWBRK
LEFT JOIN
(select WBELNV, ARKTX, WBELN from wbrp where condtion....) TWBRP
ON TWBRK.WBELN = TWBRP.WBELN
INFO : Query ID = hive_20161101051919_b644f24d-9a0e-4a41-a1b7-d988b992811f
INFO : Total jobs = 1
INFO : Starting task [Stage-5:CONDITIONAL] in parallel
INFO : Stage-1 is selected by condition resolver.
INFO : Launching Job 1 out of 1
INFO : Starting task [Stage-1:MAPRED] in parallel
INFO : Number of reduce tasks not specified. Estimated from input data size: 853
INFO : In order to change the average load for a reducer (in bytes):
INFO : set hive.exec.reducers.bytes.per.reducer=<number>
INFO : In order to limit the maximum number of reducers:
INFO : set hive.exec.reducers.max=<number>
INFO : In order to set a constant number of reducers:
INFO : set mapreduce.job.reduces=<number>
INFO : number of splits:305
INFO : Submitting tokens for job: job_1477878984962_0005
INFO : The url to track the job: .....
INFO : Starting Job = job_1477878984962_0005, Tracking URL = .....
INFO : Kill Command = /opt/cloudera/parcels/CDH-5.8.2-1.cdh5.8.2.p0.3/lib/hadoop/bin/hadoop job -kill job_1477878984962_0005
INFO : Hadoop job information for Stage-1: number of mappers: 305; number of reducers: 853
INFO : 2016-11-01 05:19:51,525 Stage-1 map = 0%, reduce = 0%
INFO : 2016-11-01 05:20:10,334 Stage-1 map = 1%, reduce = 0%, Cumulative CPU 1202.0 sec
INFO : 2016-11-01 05:20:13,526 Stage-1 map = 3%, reduce = 0%, Cumulative CPU 1927.75 sec
INFO : 2016-11-01 05:20:14,590 Stage-1 map = 4%, reduce = 0%, Cumulative CPU 2173.92 sec
INFO : 2016-11-01 05:20:16,719 Stage-1 map = 6%, reduce = 0%, Cumulative CPU 2670.75 sec
INFO : 2016-11-01 05:20:17,795 Stage-1 map = 8%, reduce = 0%, Cumulative CPU 2921.09 sec
INFO : 2016-11-01 05:20:19,924 Stage-1 map = 10%, reduce = 0%, Cumulative CPU 3443.04 sec
INFO : 2016-11-01 05:20:20,969 Stage-1 map = 11%, reduce = 0%, Cumulative CPU 3647.82 sec
INFO : 2016-11-01 05:20:22,065 Stage-1 map = 12%, reduce = 0%, Cumulative CPU 3761.91 sec
INFO : 2016-11-01 05:20:23,131 Stage-1 map = 14%, reduce = 0%, Cumulative CPU 4175.81 sec
INFO : 2016-11-01 05:20:24,170 Stage-1 map = 15%, reduce = 0%, Cumulative CPU 4395.49 sec
INFO : 2016-11-01 05:20:25,243 Stage-1 map = 16%, reduce = 0%, Cumulative CPU 4493.86 sec
INFO : 2016-11-01 05:20:26,283 Stage-1 map = 18%, reduce = 0%, Cumulative CPU 4889.57 sec
INFO : 2016-11-01 05:20:27,326 Stage-1 map = 19%, reduce = 0%, Cumulative CPU 5146.13 sec
INFO : 2016-11-01 05:20:29,459 Stage-1 map = 21%, reduce = 0%, Cumulative CPU 5591.66 sec
INFO : 2016-11-01 05:20:30,539 Stage-1 map = 23%, reduce = 0%, Cumulative CPU 5863.12 sec
INFO : 2016-11-01 05:20:32,650 Stage-1 map = 25%, reduce = 0%, Cumulative CPU 6360.4 sec
INFO : 2016-11-01 05:20:33,721 Stage-1 map = 26%, reduce = 0%, Cumulative CPU 6608.6 sec
INFO : 2016-11-01 05:20:34,791 Stage-1 map = 27%, reduce = 0%, Cumulative CPU 6739.82 sec
INFO : 2016-11-01 05:20:35,863 Stage-1 map = 29%, reduce = 0%, Cumulative CPU 7135.6 sec
INFO : 2016-11-01 05:20:36,930 Stage-1 map = 30%, reduce = 0%, Cumulative CPU 7342.27 sec
INFO : 2016-11-01 05:20:37,996 Stage-1 map = 31%, reduce = 0%, Cumulative CPU 7497.89 sec
INFO : 2016-11-01 05:20:39,058 Stage-1 map = 33%, reduce = 0%, Cumulative CPU 7855.56 sec
INFO : 2016-11-01 05:20:40,137 Stage-1 map = 34%, reduce = 0%, Cumulative CPU 8075.49 sec
INFO : 2016-11-01 05:20:41,176 Stage-1 map = 35%, reduce = 0%, Cumulative CPU 8234.62 sec
INFO : 2016-11-01 05:20:42,255 Stage-1 map = 37%, reduce = 0%, Cumulative CPU 8610.05 sec
INFO : 2016-11-01 05:20:43,331 Stage-1 map = 38%, reduce = 0%, Cumulative CPU 8805.37 sec
INFO : 2016-11-01 05:20:44,420 Stage-1 map = 39%, reduce = 0%, Cumulative CPU 8976.91 sec
INFO : 2016-11-01 05:20:45,488 Stage-1 map = 41%, reduce = 0%, Cumulative CPU 9376.58 sec
INFO : 2016-11-01 05:20:46,560 Stage-1 map = 42%, reduce = 0%, Cumulative CPU 9540.08 sec
INFO : 2016-11-01 05:20:47,631 Stage-1 map = 43%, reduce = 0%, Cumulative CPU 9724.87 sec
INFO : 2016-11-01 05:20:48,698 Stage-1 map = 45%, reduce = 0%, Cumulative CPU 10102.89 sec
INFO : 2016-11-01 05:20:50,794 Stage-1 map = 46%, reduce = 0%, Cumulative CPU 10465.3 sec
INFO : 2016-11-01 05:20:51,875 Stage-1 map = 49%, reduce = 0%, Cumulative CPU 10855.49 sec
INFO : 2016-11-01 05:20:54,011 Stage-1 map = 50%, reduce = 0%, Cumulative CPU 11202.67 sec
INFO : 2016-11-01 05:20:55,091 Stage-1 map = 51%, reduce = 0%, Cumulative CPU 11591.39 sec
INFO : 2016-11-01 05:20:56,180 Stage-1 map = 52%, reduce = 0%, Cumulative CPU 11740.18 sec
INFO : 2016-11-01 05:20:58,419 Stage-1 map = 53%, reduce = 0%, Cumulative CPU 12370.26 sec
INFO : 2016-11-01 05:20:59,480 Stage-1 map = 56%, reduce = 0%, Cumulative CPU 12520.59 sec
INFO : 2016-11-01 05:21:00,577 Stage-1 map = 62%, reduce = 0%, Cumulative CPU 12810.8 sec
INFO : 2016-11-01 05:21:01,658 Stage-1 map = 70%, reduce = 0%, Cumulative CPU 13114.72 sec
INFO : 2016-11-01 05:21:02,746 Stage-1 map = 73%, reduce = 0%, Cumulative CPU 13202.98 sec
INFO : 2016-11-01 05:21:03,789 Stage-1 map = 74%, reduce = 0%, Cumulative CPU 13238.86 sec
INFO : 2016-11-01 05:21:04,847 Stage-1 map = 75%, reduce = 0%, Cumulative CPU 13309.41 sec
INFO : 2016-11-01 05:21:05,898 Stage-1 map = 76%, reduce = 0%, Cumulative CPU 13353.54 sec
INFO : 2016-11-01 05:21:06,934 Stage-1 map = 78%, reduce = 0%, Cumulative CPU 13390.74 sec
INFO : 2016-11-01 05:21:07,985 Stage-1 map = 79%, reduce = 0%, Cumulative CPU 13407.31 sec
INFO : 2016-11-01 05:21:10,088 Stage-1 map = 80%, reduce = 0%, Cumulative CPU 13540.64 sec
INFO : 2016-11-01 05:21:11,137 Stage-1 map = 81%, reduce = 0%, Cumulative CPU 13767.89 sec
INFO : 2016-11-01 05:21:12,186 Stage-1 map = 83%, reduce = 0%, Cumulative CPU 13960.68 sec
INFO : 2016-11-01 05:21:13,234 Stage-1 map = 84%, reduce = 0%, Cumulative CPU 14062.93 sec
INFO : 2016-11-01 05:21:14,282 Stage-1 map = 85%, reduce = 0%, Cumulative CPU 14181.51 sec
INFO : 2016-11-01 05:21:15,366 Stage-1 map = 86%, reduce = 0%, Cumulative CPU 14226.94 sec
INFO : 2016-11-01 05:21:16,459 Stage-1 map = 87%, reduce = 0%, Cumulative CPU 14285.53 sec
INFO : 2016-11-01 05:21:17,524 Stage-1 map = 88%, reduce = 0%, Cumulative CPU 14350.46 sec
INFO : 2016-11-01 05:21:19,739 Stage-1 map = 89%, reduce = 0%, Cumulative CPU 14420.35 sec
INFO : 2016-11-01 05:21:24,138 Stage-1 map = 90%, reduce = 0%, Cumulative CPU 14581.82 sec
INFO : 2016-11-01 05:21:26,328 Stage-1 map = 91%, reduce = 0%, Cumulative CPU 14662.0 sec
INFO : 2016-11-01 05:21:28,418 Stage-1 map = 91%, reduce = 2%, Cumulative CPU 14902.62 sec
INFO : 2016-11-01 05:21:29,471 Stage-1 map = 92%, reduce = 4%, Cumulative CPU 15088.03 sec
INFO : 2016-11-01 05:21:30,526 Stage-1 map = 92%, reduce = 5%, Cumulative CPU 15253.04 sec
INFO : 2016-11-01 05:21:31,575 Stage-1 map = 92%, reduce = 6%, Cumulative CPU 15345.0 sec
INFO : 2016-11-01 05:21:32,627 Stage-1 map = 93%, reduce = 6%, Cumulative CPU 15419.55 sec
INFO : 2016-11-01 05:21:34,702 Stage-1 map = 94%, reduce = 7%, Cumulative CPU 15572.62 sec
INFO : 2016-11-01 05:21:36,809 Stage-1 map = 95%, reduce = 7%, Cumulative CPU 15720.87 sec
INFO : 2016-11-01 05:21:38,909 Stage-1 map = 96%, reduce = 7%, Cumulative CPU 15828.46 sec
INFO : 2016-11-01 05:21:39,966 Stage-1 map = 97%, reduce = 7%, Cumulative CPU 15906.51 sec
INFO : 2016-11-01 05:21:41,020 Stage-1 map = 98%, reduce = 7%, Cumulative CPU 15959.83 sec
INFO : 2016-11-01 05:21:43,131 Stage-1 map = 99%, reduce = 7%, Cumulative CPU 16054.37 sec
INFO : 2016-11-01 05:21:46,316 Stage-1 map = 100%, reduce = 8%, Cumulative CPU 16182.34 sec
INFO : 2016-11-01 05:21:48,483 Stage-1 map = 100%, reduce = 10%, Cumulative CPU 16429.34 sec
INFO : 2016-11-01 05:21:49,609 Stage-1 map = 100%, reduce = 12%, Cumulative CPU 16599.44 sec
INFO : 2016-11-01 05:21:50,702 Stage-1 map = 100%, reduce = 15%, Cumulative CPU 16859.14 sec
INFO : 2016-11-01 05:21:51,800 Stage-1 map = 100%, reduce = 17%, Cumulative CPU 17132.1 sec
INFO : 2016-11-01 05:21:55,227 Stage-1 map = 100%, reduce = 18%, Cumulative CPU 17848.45 sec
INFO : 2016-11-01 05:22:01,829 Stage-1 map = 100%, reduce = 19%, Cumulative CPU 19385.42 sec
INFO : 2016-11-01 05:22:05,149 Stage-1 map = 100%, reduce = 20%, Cumulative CPU 20165.94 sec
INFO : 2016-11-01 05:22:07,333 Stage-1 map = 100%, reduce = 21%, Cumulative CPU 20676.15 sec
INFO : 2016-11-01 05:22:09,583 Stage-1 map = 100%, reduce = 22%, Cumulative CPU 21173.0 sec
INFO : 2016-11-01 05:22:11,883 Stage-1 map = 100%, reduce = 23%, Cumulative CPU 21631.91 sec
INFO : 2016-11-01 05:22:14,118 Stage-1 map = 100%, reduce = 24%, Cumulative CPU 22133.32 sec
INFO : 2016-11-01 05:22:15,218 Stage-1 map = 100%, reduce = 25%, Cumulative CPU 22363.35 sec
INFO : 2016-11-01 05:22:17,480 Stage-1 map = 100%, reduce = 26%, Cumulative CPU 22777.09 sec
INFO : 2016-11-01 05:22:19,736 Stage-1 map = 100%, reduce = 27%, Cumulative CPU 23215.03 sec
INFO : 2016-11-01 05:22:23,064 Stage-1 map = 100%, reduce = 28%, Cumulative CPU 23604.45 sec
INFO : 2016-11-01 05:22:29,675 Stage-1 map = 100%, reduce = 29%, Cumulative CPU 23904.9 sec
INFO : 2016-11-01 05:22:30,973 Stage-1 map = 100%, reduce = 30%, Cumulative CPU 23987.76 sec
INFO : 2016-11-01 05:22:32,052 Stage-1 map = 100%, reduce = 31%, Cumulative CPU 24089.47 sec
INFO : 2016-11-01 05:22:33,172 Stage-1 map = 100%, reduce = 32%, Cumulative CPU 24188.51 sec
INFO : 2016-11-01 05:22:34,337 Stage-1 map = 100%, reduce = 33%, Cumulative CPU 24282.07 sec
INFO : 2016-11-01 05:22:35,447 Stage-1 map = 100%, reduce = 35%, Cumulative CPU 24468.31 sec
INFO : 2016-11-01 05:22:36,570 Stage-1 map = 100%, reduce = 37%, Cumulative CPU 24694.34 sec
INFO : 2016-11-01 05:22:37,698 Stage-1 map = 100%, reduce = 38%, Cumulative CPU 24851.7 sec
INFO : 2016-11-01 05:22:38,848 Stage-1 map = 100%, reduce = 40%, Cumulative CPU 25091.25 sec
INFO : 2016-11-01 05:22:39,966 Stage-1 map = 100%, reduce = 41%, Cumulative CPU 25375.97 sec
INFO : 2016-11-01 05:22:41,058 Stage-1 map = 100%, reduce = 42%, Cumulative CPU 25553.66 sec
INFO : 2016-11-01 05:22:42,199 Stage-1 map = 100%, reduce = 43%, Cumulative CPU 25785.05 sec
INFO : 2016-11-01 05:22:43,319 Stage-1 map = 100%, reduce = 44%, Cumulative CPU 26048.21 sec
INFO : 2016-11-01 05:22:45,555 Stage-1 map = 100%, reduce = 45%, Cumulative CPU 26454.59 sec
INFO : 2016-11-01 05:22:47,750 Stage-1 map = 100%, reduce = 46%, Cumulative CPU 26970.97 sec
INFO : 2016-11-01 05:22:48,837 Stage-1 map = 100%, reduce = 47%, Cumulative CPU 27210.35 sec
INFO : 2016-11-01 05:22:51,061 Stage-1 map = 100%, reduce = 48%, Cumulative CPU 27752.7 sec
INFO : 2016-11-01 05:22:53,336 Stage-1 map = 100%, reduce = 49%, Cumulative CPU 28285.81 sec
INFO : 2016-11-01 05:22:55,553 Stage-1 map = 100%, reduce = 50%, Cumulative CPU 28762.43 sec
INFO : 2016-11-01 05:22:58,900 Stage-1 map = 100%, reduce = 51%, Cumulative CPU 29489.7 sec
INFO : 2016-11-01 05:23:01,087 Stage-1 map = 100%, reduce = 52%, Cumulative CPU 29946.92 sec
INFO : 2016-11-01 05:23:03,329 Stage-1 map = 100%, reduce = 53%, Cumulative CPU 30397.54 sec
INFO : 2016-11-01 05:23:05,681 Stage-1 map = 100%, reduce = 54%, Cumulative CPU 30800.85 sec
INFO : 2016-11-01 05:23:06,773 Stage-1 map = 100%, reduce = 55%, Cumulative CPU 31014.07 sec
INFO : 2016-11-01 05:23:10,221 Stage-1 map = 100%, reduce = 56%, Cumulative CPU 31489.0 sec
INFO : 2016-11-01 05:23:12,450 Stage-1 map = 100%, reduce = 57%, Cumulative CPU 31712.91 sec
INFO : 2016-11-01 05:23:14,691 Stage-1 map = 100%, reduce = 58%, Cumulative CPU 31892.23 sec
INFO : 2016-11-01 05:23:16,966 Stage-1 map = 100%, reduce = 59%, Cumulative CPU 32056.41 sec
INFO : 2016-11-01 05:23:18,090 Stage-1 map = 100%, reduce = 60%, Cumulative CPU 32179.45 sec
INFO : 2016-11-01 05:23:20,275 Stage-1 map = 100%, reduce = 61%, Cumulative CPU 32422.81 sec
INFO : 2016-11-01 05:23:21,361 Stage-1 map = 100%, reduce = 62%, Cumulative CPU 32557.59 sec
INFO : 2016-11-01 05:23:22,451 Stage-1 map = 100%, reduce = 63%, Cumulative CPU 32678.22 sec
INFO : 2016-11-01 05:23:23,600 Stage-1 map = 100%, reduce = 64%, Cumulative CPU 32839.1 sec
INFO : 2016-11-01 05:23:24,723 Stage-1 map = 100%, reduce = 65%, Cumulative CPU 33012.26 sec
INFO : 2016-11-01 05:23:25,901 Stage-1 map = 100%, reduce = 66%, Cumulative CPU 33185.33 sec
INFO : 2016-11-01 05:23:27,033 Stage-1 map = 100%, reduce = 67%, Cumulative CPU 33413.55 sec
INFO : 2016-11-01 05:23:28,129 Stage-1 map = 100%, reduce = 69%, Cumulative CPU 33630.55 sec
INFO : 2016-11-01 05:23:29,201 Stage-1 map = 100%, reduce = 70%, Cumulative CPU 33851.67 sec
INFO : 2016-11-01 05:23:30,303 Stage-1 map = 100%, reduce = 71%, Cumulative CPU 34033.29 sec
INFO : 2016-11-01 05:23:31,410 Stage-1 map = 100%, reduce = 72%, Cumulative CPU 34296.61 sec
INFO : 2016-11-01 05:23:32,535 Stage-1 map = 100%, reduce = 73%, Cumulative CPU 34534.44 sec
INFO : 2016-11-01 05:23:33,679 Stage-1 map = 100%, reduce = 74%, Cumulative CPU 34737.27 sec
INFO : 2016-11-01 05:23:34,752 Stage-1 map = 100%, reduce = 75%, Cumulative CPU 34979.43 sec
INFO : 2016-11-01 05:23:37,021 Stage-1 map = 100%, reduce = 76%, Cumulative CPU 35511.73 sec
INFO : 2016-11-01 05:23:40,367 Stage-1 map = 100%, reduce = 77%, Cumulative CPU 36188.62 sec
INFO : 2016-11-01 05:23:41,748 Stage-1 map = 100%, reduce = 78%, Cumulative CPU 36470.54 sec
INFO : 2016-11-01 05:23:45,101 Stage-1 map = 100%, reduce = 79%, Cumulative CPU 37183.85 sec
INFO : 2016-11-01 05:23:47,375 Stage-1 map = 100%, reduce = 80%, Cumulative CPU 37647.46 sec
INFO : 2016-11-01 05:23:49,703 Stage-1 map = 100%, reduce = 81%, Cumulative CPU 38113.9 sec
INFO : 2016-11-01 05:23:50,865 Stage-1 map = 100%, reduce = 82%, Cumulative CPU 38352.23 sec
INFO : 2016-11-01 05:23:53,078 Stage-1 map = 100%, reduce = 83%, Cumulative CPU 38739.22 sec
INFO : 2016-11-01 05:23:54,232 Stage-1 map = 100%, reduce = 84%, Cumulative CPU 38969.44 sec
INFO : 2016-11-01 05:23:56,427 Stage-1 map = 100%, reduce = 85%, Cumulative CPU 39301.84 sec
INFO : 2016-11-01 05:23:59,912 Stage-1 map = 100%, reduce = 86%, Cumulative CPU 39776.8 sec
INFO : 2016-11-01 05:24:01,000 Stage-1 map = 100%, reduce = 87%, Cumulative CPU 39895.9 sec
INFO : 2016-11-01 05:24:03,206 Stage-1 map = 100%, reduce = 88%, Cumulative CPU 40158.17 sec
INFO : 2016-11-01 05:24:05,403 Stage-1 map = 100%, reduce = 89%, Cumulative CPU 40369.82 sec
INFO : 2016-11-01 05:24:06,495 Stage-1 map = 100%, reduce = 90%, Cumulative CPU 40571.76 sec
INFO : 2016-11-01 05:24:08,735 Stage-1 map = 100%, reduce = 92%, Cumulative CPU 41004.2 sec
INFO : 2016-11-01 05:24:09,854 Stage-1 map = 100%, reduce = 93%, Cumulative CPU 41252.37 sec
INFO : 2016-11-01 05:24:10,999 Stage-1 map = 100%, reduce = 94%, Cumulative CPU 41529.78 sec
INFO : 2016-11-01 05:24:12,122 Stage-1 map = 100%, reduce = 95%, Cumulative CPU 41862.09 sec
INFO : 2016-11-01 05:24:13,241 Stage-1 map = 100%, reduce = 96%, Cumulative CPU 42124.96 sec
INFO : 2016-11-01 05:24:15,400 Stage-1 map = 100%, reduce = 97%, Cumulative CPU 42596.22 sec
INFO : 2016-11-01 05:24:18,654 Stage-1 map = 100%, reduce = 98%, Cumulative CPU 43166.7 sec
INFO : 2016-11-01 05:24:21,817 Stage-1 map = 100%, reduce = 99%, Cumulative CPU 43557.51 sec
INFO : 2016-11-01 05:24:29,135 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 43925.39 sec
INFO : MapReduce Total cumulative CPU time: 0 days 12 hours 12 minutes 5 seconds 390 msec
INFO : Ended Job = job_1477878984962_0005
INFO : Starting task [Stage-0:MOVE] in serial mode
INFO : Moving data to: .......
INFO : Starting task [Stage-6:DDL] in serial mode
INFO : Starting task [Stage-2:STATS] in serial mode
INFO : Table lol_ca_sap_dsd_c.tmptbl_lol_ca_sap_dsd_pr_sc2 stats: [numFiles=853, numRows=829962807, totalSize=81514377225, rawDataSize=80684414418]
INFO : MapReduce Jobs Launched:
INFO : Stage-Stage-1: Map: 305 Reduce: 853 Cumulative CPU: 43925.39 sec HDFS Read: 57222810740 HDFS Write: 81514472496 SUCCESS
INFO : Total MapReduce CPU Time Spent: 0 days 12 hours 12 minutes 5 seconds 390 msec
INFO : Completed executing command(queryId=hive_20161101051919_b644f24d-9a0e-4a41-a1b7-d988b992811f); Time taken: 310.066 seconds
INFO : OK
No rows affected (310.8 seconds)

[#2]

Could you let us know the version you are using ? 

Also as far I am concered only  left semi joins are supported in Hive. 

[#3]

Hi Csguna,

I am using hive-1.1.0 in cdh5.8.2 version.

There is no issue in result by left join, btw join is not problem here. I am consirned about stages running parallelly.