I checked map join behaviour, When I use more than one table in map join
without serde it works perfectly fine , But it does not work with Serde for
more than one tables. I checked the code, I found the class called
MapJoinOperator.java have joinKeys variable,It have null value when I use serde
Hi Namit,
Here is the query which I am trying to run :-
select /*+ MAPJOIN(region,carrier ) */
region.reg,carrier.country,count(column1) from foo join carrier on
(foo.column10 =carrier.id) join region on
(carrier.country=region.country) where foo.rq_dt = '2010-12-16-00' AND
carrier.rq_dt = '2010
Can you send the exact query along with the schema of the tables ?
On 12/23/10 1:48 AM, "jaydeep vishwakarma"
wrote:
>Hi,
>
>I am trying to running some MAPJOIN queries. When I am placing single
>table in MAP JOIN it works fine,But when I run same query with two
>tables on MAPJOIN it gives erro
Hi,
I am trying to running some MAPJOIN queries. When I am placing single
table in MAP JOIN it works fine,But when I run same query with two
tables on MAPJOIN it gives error. Can any tell me what could be the
problem? Here is the error log which I am getting from job tracker.
java.lang.RuntimeE
