You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Jamie F Olson (JIRA)" <ji...@apache.org> on 2012/09/24 19:14:08 UTC

[jira] [Created] (HIVE-3503) Cannot compose UDAF and UDF functions

Jamie F Olson created HIVE-3503:
-----------------------------------

             Summary: Cannot compose UDAF and UDF functions
                 Key: HIVE-3503
                 URL: https://issues.apache.org/jira/browse/HIVE-3503
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.8.1
         Environment: Debian squeeze, Amazon EMR, Hadoop 1.0.3, Hive 0.8.1
            Reporter: Jamie F Olson


With an array column:
CREATE TABLE test (val ARRAY<INT>);

You are not allowed to combine aggregate and regular functions, a la:

SELECT MAX(val) > 0 FROM test;

Argument type mismatch 'val': The 1st argument of GREATER THAN  is expected to a primitive type, but list is found

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (HIVE-3503) Cannot compose UDAF and UDF functions

Posted by "Navis (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463593#comment-13463593 ] 

Navis commented on HIVE-3503:
-----------------------------

Current implementation of GT(">") does not support comparing array type. You can make one that supports array type as input.
                
> Cannot compose UDAF and UDF functions
> -------------------------------------
>
>                 Key: HIVE-3503
>                 URL: https://issues.apache.org/jira/browse/HIVE-3503
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.1
>         Environment: Debian squeeze, Amazon EMR, Hadoop 1.0.3, Hive 0.8.1
>            Reporter: Jamie F Olson
>
> With an array column:
> CREATE TABLE test (val ARRAY<INT>);
> You are not allowed to combine aggregate and regular functions, a la:
> SELECT MAX(val) > 0 FROM test;
> Argument type mismatch 'val': The 1st argument of GREATER THAN  is expected to a primitive type, but list is found

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira