Can you send the exact query along with the schema of the tables ?
On 12/23/10 1:48 AM, "jaydeep vishwakarma" <jaydeep.vishwaka...@mkhoj.com>
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 error. Can any tell me what could be the
>problem? Here is the error log which I am getting from job tracker.
>
>
>java.lang.RuntimeException:
>org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error
>while processing row
>{"_col0":"5","_col87":"2010-12-16-00","_col89":"China","_col91":"2010-12-1
>5-20"}
> at
>org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:171)
> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:358)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:307)
> at org.apache.hadoop.mapred.Child.main(Child.java:170)
>Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime
>Error while processing row
>{"_col0":"5","_col87":"2010-12-16-00","_col89":"China","_col91":"2010-12-1
>5-20"}
> at
>org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:417)
> at
>org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:153)
> ... 4 more
>Caused by: java.lang.NullPointerException
> at
>org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.j
>ava:177)
> at
>org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:457)
> at
>org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:697)
> at
>org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.jav
>a:84)
> at
>org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:457)
> at
>org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:697)
> at
>org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:400)
> ... 5 more
>
>Regard,
>Jaydeep
>
>The information contained in this communication is intended solely for
>the use of the individual or entity to whom it is addressed and others
>authorized to receive it. It may contain confidential or legally
>privileged information. If you are not the intended recipient you are
>hereby notified that any disclosure, copying, distribution or taking any
>action in reliance on the contents of this information is strictly
>prohibited and may be unlawful. If you have received this communication
>in error, please notify us immediately by responding to this email and
>then delete it from your system. The firm is neither liable for the
>proper and complete transmission of the information contained in this
>communication nor for any delay in its receipt.
