[ 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