hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "YihueyChyi (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-89) avg() min() max() will get error message
Date Mon, 01 Dec 2008 07:52:44 GMT
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.2.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.


Mime
View raw message