You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "YihueyChyi (JIRA)" <ji...@apache.org> on 2008/12/01 09:52:44 UTC

[jira] Updated: (HIVE-89) avg() min() max() will get error message

     [ https://issues.apache.org/jira/browse/HIVE-89?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

YihueyChyi updated HIVE-89:
---------------------------

    Environment: hadoop 0.17.2.1 hive 0.17.0  (was: hadoop 0.17.2.1 hive 0.2.0)

> avg() min() max() will get error message
> ----------------------------------------
>
>                 Key: HIVE-89
>                 URL: https://issues.apache.org/jira/browse/HIVE-89
>             Project: Hadoop Hive
>          Issue Type: Bug
>         Environment: hadoop 0.17.2.1 hive 0.17.0
>            Reporter: YihueyChyi
>
> When I run select min() , max() or avg() ,I will get error message
> Test table : data rows: 15835023
> error message: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver
> Hadoop web:50030 message
> From reduce process
> java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.reflect.InvocationTargetException
> 	at org.apache.hadoop.hive.ql.exec.ExecReducer.reduce(ExecReducer.java:173)
> 	at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:391)
> 	at org.apache.hadoop.mapred.TaskTracker$Child.main(TaskTracker.java:2122)
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.reflect.InvocationTargetException
> 	at org.apache.hadoop.hive.ql.exec.GroupByOperator.process(GroupByOperator.java:243)
> 	at org.apache.hadoop.hive.ql.exec.ExecReducer.reduce(ExecReducer.java:168)
> 	... 2 more
> Caused by: java.lang.reflect.InvocationTargetException
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at org.apache.hadoop.hive.ql.exec.GroupByOperator.updateAggregations(GroupByOperator.java:210)
> 	at org.apache.hadoop.hive.ql.exec.GroupByOperator.processAggr(GroupByOperator.java:297)
> 	at org.apache.hadoop.hive.ql.exec.GroupByOperator.process(GroupByOperator.java:240)
> 	... 3 more
> Caused by: java.lang.NumberFormatException: For input string: "2004-12-22"
> 	at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1224)
> 	at java.lang.Double.parseDouble(Double.java:510)
> 	at org.apache.hadoop.hive.ql.udf.UDAFAvg.aggregate(UDAFAvg.java:42)
> 	... 10 more
>  

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.