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] Commented: (HIVE-89) avg() min() max() will get error message
Date Tue, 02 Dec 2008 06:47:44 GMT

    [ https://issues.apache.org/jira/browse/HIVE-89?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12652294#action_12652294
] 

YihueyChyi commented on HIVE-89:
--------------------------------

Hi Zheng Shao,
 
    But min , max  can't for date type .It's very useful function for date type .  
  
    Can you have plan for this demand?  

> 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
>          Components: Query Processor
>         Environment: hadoop 0.17.2.1 hive 0.17.0
>            Reporter: YihueyChyi
>            Assignee: Zheng Shao
>
> 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