[ https://issues.apache.org/jira/browse/HIVE-89?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-89: ------------------------------- Fix Version/s: 0.3.0 > avg() min() max() will get error message > ---------------------------------------- > > Key: HIVE-89 > URL: https://issues.apache.org/jira/browse/HIVE-89 > Project: Hive > Issue Type: Bug > Components: Query Processor > Environment: hadoop 0.17.2.1 hive 0.17.0 > Reporter: YihueyChyi > Assignee: Zheng Shao > Fix For: 0.3.0 > > > 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. For more information on JIRA, see: http://www.atlassian.com/software/jira