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

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


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/