hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Chang (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2509) Literal bigint
Date Wed, 19 Oct 2011 23:49:12 GMT

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

Jonathan Chang commented on HIVE-2509:
--------------------------------------

There are two issues:

1.) There are actually lots of UDFs which are pretty sensitive to type.  In particular, widening
will not handle cases where array<int> needs to be widened to array<bigint> (there's
a reason this sort of thing isn't autocasted in C++, Java, etc.).
2.) I generally think widening is a bad idea because it makes people less careful with types.
 For example, without looking, what will 

> explain select * from (select '0' from akramer_one_row union all select 12345678900 from
akramer_one_row) a;

return as the type of the outer query?  The answer is pretty terrible; if any other language
did this to you you'd be pretty furious.
                
> Literal bigint
> --------------
>
>                 Key: HIVE-2509
>                 URL: https://issues.apache.org/jira/browse/HIVE-2509
>             Project: Hive
>          Issue Type: New Feature
>            Reporter: Jonathan Chang
>            Assignee: Jonathan Chang
>         Attachments: D15.1.patch, D15.1.patch
>
>
> Typing bigints is a pain because you have to write CAST(0 AS BIGINT).  We should let
people type 0L instead.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message