You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Phabricator (JIRA)" <ji...@apache.org> on 2013/03/02 03:23:15 UTC

[jira] [Commented] (HIVE-3490) Implement * or a.* for arguments to UDFs

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

Phabricator commented on HIVE-3490:
-----------------------------------

navis has commented on the revision "HIVE-3490 [jira] Implement * or a.* for arguments to UDFs".

INLINE COMMENTS
  ql/src/test/queries/clientpositive/allcolref_in_udf.q:4 ok.
  ql/src/test/queries/clientpositive/allcolref_in_udf.q:9 ok.
  ql/src/test/queries/clientpositive/allcolref_in_udf.q:8 it's decided by the row schema of prev operator. For joins, it's left most alias to right. Added comments.

REVISION DETAIL
  https://reviews.facebook.net/D8889

To: JIRA, navis
Cc: njain

                
> Implement * or a.* for arguments to UDFs
> ----------------------------------------
>
>                 Key: HIVE-3490
>                 URL: https://issues.apache.org/jira/browse/HIVE-3490
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor, UDF
>            Reporter: Adam Kramer
>            Assignee: Navis
>         Attachments: HIVE-3490.D8889.1.patch, HIVE-3490.D8889.2.patch
>
>
> For a random UDF, we should be able to use * or a.* to refer to "all of the columns in their natural order." This is not currently implemented.
> I'm reporting this as a bug because it is a manner in which Hive is inconsistent with the SQL spec, and because Hive claims to implement *.
> hive> select all_non_null(a.*) from table a where a.ds='2012-09-01';
> FAILED: ParseException line 1:25 mismatched input '*' expecting Identifier near '.' in expression specification

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