[HIVE-2427] Warn user that precision is lost when bigint is implicitly cast to double in joins and unions.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Kevin Wilfong
• Reporter: Kevin Wilfong
• Created: 02/Sep/11 16:48
• Updated: 17/Jul/12 07:46

Description

When a bigint is implicitly cast to a double (when a bigint is involved in an equality expression with a string or double as part of a join condition, or when a bigint column is to be combined with a string or double column as part of a union) precision may be lost, resulting in unexpected behavior. Until we fix the underlying issue we should throw an error in strict mode, and a warning in nonstrict mode alerting the user about this.