Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Stacktrace on 3 way join


Copy link to this message
-
Stacktrace on 3 way join
Juan P. 2013-02-01, 18:02
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)
+
Vinod Kumar Vavilapalli 2013-02-01, 19:39