[ 
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

        

Reply via email to