You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/02/11 02:06:13 UTC

[jira] [Created] (DRILL-2207) Union All on two tables with different column names give confusing result

Sean Hsuan-Yi Chu created DRILL-2207:
----------------------------------------

             Summary: Union All on two tables with different column names give confusing result
                 Key: DRILL-2207
                 URL: https://issues.apache.org/jira/browse/DRILL-2207
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Sean Hsuan-Yi Chu
            Assignee: Sean Hsuan-Yi Chu
            Priority: Critical


For instance,
(select n_name from cp.`tpch/nation.parquet` limit 1)" +
            "UNION ALL " +
         "(select r_name from cp.`tpch/region.parquet` limit 1);

returns:

n_name
ALGERIA
r_name
AFRICA



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)