You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Rob Paul <ur...@gmail.com> on 2014/03/18 01:33:05 UTC

Fwd: Hive-0.9 errors out when I run order by with timestamp datatype colums

sorry about cross posting.. have someone encountered this in the past?


---------- Forwarded message ----------
From: Rob Paul <ur...@gmail.com>
Date: Fri, Mar 14, 2014 at 5:07 PM
Subject: Hive-0.9 errors out when I run order by with timestamp datatype colums
To: user@hive.apache.org


Has anyone seen this error? Any workaround:

: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error
while processing row (tag=0)
{"key":{"reducesinkkey0":1},"value":{"_col0":1,"_col1":"aaaaaaa","_col2":"bbbbbbbb","_col3":"cccccccc","_col4":1,"_col5":"eeee","_col6":"2010-09-10
01:11:01","_col7":"1980-02-05 05:09:22.565544444"},"alias":0}

        at org.apache.hadoop.hive.ql.exec.ExecReducer.reduce(ExecReducer.java:270)

        ... 17 more

Caused by: java.lang.ArrayIndexOutOfBoundsException

        at java.lang.System.arraycopy(Native Method)

        at org.apache.hadoop.io.Text.set(Text.java:205)

        at org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryString.init(LazyBinaryString.java:48)

        at org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct.uncheckedGetField(LazyBinaryStruct.java:216)

        at org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct.getFieldsAsList(LazyBinaryStruct.java:238)

        at org.apache.hadoop.hive.serde2.lazybinary.objectinspector.LazyBinaryStructObjectInspector.getStructFieldsDataAsList(LazyBinaryStructObjectInspector.java:70)

        at org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.serialize(LazySimpleSerDe.java:338)

        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.processOp(FileSinkOperator.java:586)

        at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:472)

        at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:812)

        at org.apache.hadoop.hive.ql.exec.ExtractOperator.processOp(ExtractOperator.java:45)

        at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:472)

        at org.apache.hadoop.hive.ql.exec.ExecReducer.reduce(ExecReducer.java:261)

        ... 17 more