AnsweredAssumed Answered

Map Join is a Cross Product

Question asked by gr8rajas on Nov 8, 2016
Latest reply on Nov 18, 2016 by gr8rajas

I am running a Hive Query  and it was launching  30+ jobs and I am a getting a warning 

Warning: Map Join MAPJOIN[436][bigTable=?] in task 'Stage-66:MAPRED' is a cross product

 

I have enabled Map join and I have also removed ANSI SQL Joins.

Still I am seeing the Warning.

 

I am getting the result but I want to get rid of the Warning.

Warning: Map Join MAPJOIN[436][bigTable=?] in task 'Stage-66:MAPRED' is a cross product

Outcomes