hive-dev mailing list archives

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


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:
>             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:!default.jspa
For more information on JIRA, see:


View raw message