Re: Reduce the number of map/reduce jobs during join

Do the joins share the same key？ 2012/3/13 Bruce Bian > Yes,it's in my hive-default.xml and Hive figured to use one reducer only, > so I thought increase it to 5 might help,which doesn't. > Anyway, to scan the largest table 6 times isn't efficient hence my > question. > > > On Wed, Mar 14, 2012

About Re-write complex SQL query

*Hi all: Is there any software or website which can rewrite complex query with sub-query in the WHERE clause to be in the FROM clause?? So that it can be supported by HIVE.* *Best Regards* *Eugene z. Von*