[HIVE-285] UNION ALL does not allow different types in the same column

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.3.0, 0.6.0
• Fix Version/s: 0.3.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Raghotham Murthy
• Reporter: Zheng Shao
• Created: 10/Feb/09 01:49
• Updated: 17/Dec/11 00:09
• Resolved: 18/Mar/09 18:29

Description

explain INSERT OVERWRITE TABLE t
    SELECT s.r, s.c, sum(s.v) FROM
    (
      SELECT a.r AS r, a.c AS c, a.v AS v FROM t1 a
      UNION ALL
      SELECT b.r AS r, b.c AS c, 0 + b.v AS v FROM t2 b
    ) s
    GROUP BY s.r, s.c;

Both a and b have 3 string columns: r, c, and v.

It compiled successfully but failed during runtime.
"Explain" shows that the plan for the 2 union-all operands have different output types that are converged to STRING, but there is no UDFToString inserted for "0 + b.v AS v" and as a result, SerDe was failing because it expects a String but is passed a Double.

Issue Links

• is related to: HIVE-297 Parses doesn't catch certain type errors.