hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vinod Kumar Vavilapalli <vino...@hortonworks.com>
Subject Re: Stacktrace on 3 way join
Date Fri, 01 Feb 2013 19:39:42 GMT
What are the underlying serdes for all your tables?

+Vinod


On Fri, Feb 1, 2013 at 10:02 AM, Juan P. <gordoslocos@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/

Mime
View raw message