You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Xuefu Zhang (JIRA)" <ji...@apache.org> on 2013/12/16 23:43:08 UTC

[jira] [Updated] (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:all-tabpanel ]

Xuefu Zhang updated HIVE-6039:
------------------------------

    Attachment: HIVE-6039.patch

> 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)