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

Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2016/03/25 00:43:25 UTC

[jira] [Created] (DRILL-4540) Queries with UNION fails with data type mis-match for limit 0

Krystal created DRILL-4540:
------------------------------

             Summary: Queries with UNION fails with data type mis-match for limit 0
                 Key: DRILL-4540
                 URL: https://issues.apache.org/jira/browse/DRILL-4540
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Krystal
            Assignee: Sean Hsuan-Yi Chu


git.commit.id.abbrev=fb09973

The following queries returns different data types between with and without limit 0:

SELECT c1 FROM `union_01.parquet` UNION SELECT c2 FROM `union_02.parquet`

limit 0: [INTEGER]
regular: [BIGINT]

SELECT c2 FROM `union_01.parquet` UNION SELECT c8 FROM `union_02.parquet`

limit 0: [BIGINT]
regular: [DOUBLE]



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