drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4554) Data type mismatch for union all with timestamp and date
Date Tue, 29 Mar 2016 22:56:25 GMT
Krystal created DRILL-4554:
------------------------------

             Summary: Data type mismatch for union all with timestamp and date
                 Key: DRILL-4554
                 URL: https://issues.apache.org/jira/browse/DRILL-4554
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Krystal
            Assignee: Sean Hsuan-Yi Chu


Calcite and drill execute different implicit cast when a union all query contains timestamp
and date on both right and left hand side but in different order.

select col_tmstmp,col_date, col_boln from `prqUnAll_0_v` union all select col_date, col_tmstmp,
col_boln from `prqUnAll_1_v`

limit 0: select * from (select col_tmstmp,col_date, col_boln from `prqUnAll_0_v` union all
select col_date, col_tmstmp, col_boln from `prqUnAll_1_v`) t limit 0
limit 0: [col_tmstmp, col_date, col_boln]
regular: [col_tmstmp, col_date, col_boln]

limit 0: [DATE, DATE, BOOLEAN]
regular: [TIMESTAMP, TIMESTAMP, BOOLEAN]

limit 0: [columnNullable, columnNullable, columnNullable]
regular: [columnNullable, columnNullable, columnNullable]



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

Mime
View raw message