Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hive-dev@hadoop.apache.org
Message-ID: <1360893232.1235170870114.JavaMail.jira@brutus>
Date: Fri, 20 Feb 2009 15:01:10 -0800 (PST)
From: "Raghotham Murthy (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Subject: [jira] Assigned: (HIVE-285) UNION ALL does not allow different
 types in the same column
In-Reply-To: <1372394387.1234230659676.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Raghotham Murthy reassigned HIVE-285:
-------------------------------------

    Assignee: Raghotham Murthy

> UNION ALL does not allow different types in the same column
> -----------------------------------------------------------
>
>                 Key: HIVE-285
>                 URL: https://issues.apache.org/jira/browse/HIVE-285
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.2.0, 0.3.0
>            Reporter: Zheng Shao
>            Assignee: Raghotham Murthy
>
> {code}
> 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;
> {code}
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.