You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "Juan P." <go...@gmail.com> on 2013/02/01 19:02:11 UTC
Stacktrace on 3 way join
Guys,
I'm seeing the following stacktrace when trying to do a join between three
tables in Hive 0.8.1.
The statement looks like this:
select * from table1 t1 inner join table2 t2 on t1.field1 = t2.field1 inner
join table3 t3 on t2.field2 = t3.field2
Any ideas?
java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException:
Hive Runtime Error while processing row [Error getting row data with
exception j
ava.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to
org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct
at org.apache.hadoop.hive.serde2.lazybinary.objectinspector.
LazyBinaryStructObjectInspector.getStructFieldData(
LazyBinaryStructObjectInspector.java:55
)
at org.apache.hadoop.hive.serde2.SerDeUtils.buildJSONString(
SerDeUtils.java:343)
at org.apache.hadoop.hive.serde2.SerDeUtils.getJSONString(
SerDeUtils.java:213)
at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:540)
at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:143)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:441)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:377)
at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
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:1132)
at org.apache.hadoop.mapred.Child.main(Child.java:249)
Re: Stacktrace on 3 way join
Posted by Vinod Kumar Vavilapalli <vi...@hortonworks.com>.
What are the underlying serdes for all your tables?
+Vinod
On Fri, Feb 1, 2013 at 10:02 AM, Juan P. <go...@gmail.com> wrote:
> Guys,
>
> I'm seeing the following stacktrace when trying to do a join between three
> tables in Hive 0.8.1.
>
> The statement looks like this:
>
> select * from table1 t1 inner join table2 t2 on t1.field1 = t2.field1
> innerjoin table3 t3 on t2.field2 = t3.field2
>
> Any ideas?
>
>
> java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException:
> Hive Runtime Error while processing row [Error getting row data with
> exception j
> ava.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to
> org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct
> at org.apache.hadoop.hive.serde2.lazybinary.objectinspector.
> LazyBinaryStructObjectInspector.getStructFieldData(
> LazyBinaryStructObjectInspector.java:55
> )
> at org.apache.hadoop.hive.serde2.SerDeUtils.buildJSONString(
> SerDeUtils.java:343)
> at org.apache.hadoop.hive.serde2.SerDeUtils.getJSONString(
> SerDeUtils.java:213)
> at org.apache.hadoop.hive.ql.exec.MapOperator.process(
> MapOperator.java:540)
> at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:143)
> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:441)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:377)
> at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
> 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:1132)
> at org.apache.hadoop.mapred.Child.main(Child.java:249)
>
--
+Vinod
Hortonworks Inc.
http://hortonworks.com/