Can you try this script?
create table table_llv_N_C as select
a.chromosome_number,
a.position,
b.id
from (select * from table_line_n_passed where chromosome_number is not
null) a
join
table_line_c_passed b
on
a.chromosome_number=b.chromosome_number;
On Thu, Mar 5, 2015 at 1:41 PM, Vikram Dixit <vik...@hortonworks.com> wrote:
> Hi Krish,
>
> Which version of hive are you using? Can you also provide the logs for
> this run?
>
> Regards
> Vikram.
>
> From: krish <kri22go...@gmail.com>
> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
> Date: Thursday, March 5, 2015 at 3:14 AM
> To: "user-i...@hive.apache.org" <user-i...@hive.apache.org>, "
> user@hive.apache.org" <user@hive.apache.org>
> Subject: Fwd: Row exception in Hive while using join
>
>
> I got the following exception while executing join on Hive Query and
> reducer hang after 68% completion.
>
>
> java.lang.RuntimeException:
> org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while
> processing row (tag=1)
> {"key":{"joinkey0":"12"},"value":{"_col2":"rs317647905"},"alias":1}
> at
> org.apache.hadoop.hive.ql.exec.ExecReducer.reduce(ExecReducer.java:270)
> at
> org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:506)
> at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:447)
> at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:396)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1438)
> at org.apache.hadoop.mapred.Child.main(Child.java:262)
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime
> Error while processing row (tag=1)
> {"key":{"joinkey0":"12"},"value":{"_col2":"rs317647905"},"alias":1}
> at
> org.apache.hadoop.hive.ql.exec.ExecReducer.reduce(ExecReducer.java:258)
> ... 7 more
> Caused by: org.apache.hadoop.
>
> ---------------------------------------------------------------------------------------
>
> my query and table structure:
>
> create table table_llv_N_C as select
> table_line_n_passed.chromosome_number,table_line_n_passed.position,
> table_line_c_passed.id from table_line_n_passed join table_line_c_passed
> on
> (table_line_n_passed.chromosome_number=table_line_c_passed.chromosome_number)
>
> hive> desc table_line_n_passed;
> OK
> chromosome_number string
>
> position int
> id string
> ref string
> alt string
> quality double
> filter string
> info string
> format string
> line6 string
> Time taken: 0.854 seconds
> Why am I getting this error, and how can I solve it?
>
>
>
>
>
> --
> with regards
> krish!!!!!!
>
