Does the join query works differently on hive? : I have a join query (that joins 4 table) on mysql returns 2 rows while on Hive returns OK results. So i checked table individually on hive and mysql side. Records on each table on both side matches but results doesn't match.

Is the OK results on hive an issue. 

Below is the part of the result: 

Stage-Stage-6: Map: 2  Reduce: 1   Cumulative CPU: 22.22 sec   MAPRFS Read: 0 MAPRFS Write: 0 SUCCESS
Stage-Stage-7: Map: 2  Reduce: 1   Cumulative CPU: 24.94 sec   MAPRFS Read: 0 MAPRFS Write: 0 SUCCESS
Stage-Stage-8: Map: 2  Reduce: 1   Cumulative CPU: 22.25 sec   MAPRFS Read: 0 MAPRFS Write: 0 SUCCESS
Total MapReduce CPU Time Spent: 2 minutes 36 seconds 110 msec
OK
Time taken: 411.225 seconds
hive>


