You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hive QA (JIRA)" <ji...@apache.org> on 2013/12/17 00:38:07 UTC
[jira] [Commented] (HIVE-6039) Round, AVG and SUM functions reject
char/varch input while accepting string input
[ https://issues.apache.org/jira/browse/HIVE-6039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13849869#comment-13849869 ]
Hive QA commented on HIVE-6039:
-------------------------------
{color:green}Overall{color}: +1 all checks pass
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12618986/HIVE-6039.patch
{color:green}SUCCESS:{color} +1 4790 tests passed
Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/658/testReport
Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/658/console
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12618986
> Round, AVG and SUM functions reject char/varch input while accepting string input
> ---------------------------------------------------------------------------------
>
> Key: HIVE-6039
> URL: https://issues.apache.org/jira/browse/HIVE-6039
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Reporter: Xuefu Zhang
> Assignee: Xuefu Zhang
> Fix For: 0.13.0
>
> Attachments: HIVE-6039.patch
>
>
> An error similar to the following will occur:
> {code}
> hive> create table tabs (c char(8), vc varchar(10)) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
> hive> select sum(c), avg(c), sum(vc), avg(vc) from tabs;
> FAILED: UDFArgumentTypeException Only numeric or string type arguments are accepted but char(8) is passed.
> {code}
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)