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 Plain View
Hive >> mail # user >> Stacktrace on 3 way join


+
Juan P. 2013-02-01, 18:02
Copy link to this message
-
Re: Stacktrace on 3 way join
What are the underlying serdes for all your tables?

+Vinod
On Fri, Feb 1, 2013 at 10:02 AM, Juan P. <[EMAIL PROTECTED]> 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/
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