Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Best way to avoid cross join


Copy link to this message
-
Re: Best way to avoid cross join
Nitin Pawar 2014-03-19, 12:52
from the mail thread's last line

The correct fix would be to have 1 reducer in case of a Cartesian
product

hack to avoid this was (1 = 1). I think that's been taken care by the
hash partitioner  to go to single reducer.

Other option (atleast for me) looks like to go PIG script. Never tried
so you may give it a shot.

On Wed, Mar 19, 2014 at 6:00 PM, fab wol <[EMAIL PROTECTED]> wrote:

Nitin Pawar