Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Stacktrace on 3 way join


Copy link to this message
-
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)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB