What are the underlying serdes for all your tables? +Vinod
On Fri, Feb 1, 2013 at 10:02 AM, Juan P. <gordoslo...@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/