[jira] [Created] (DRILL-2546) Implicit Cast : Joining 2 tables on columns which are float and double should succeed when the values are equal

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

Rahul Challapalli created DRILL-2546:
----------------------------------------

             Summary: Implicit Cast : Joining 2 tables on columns which are float and double should succeed when the values are equal
                 Key: DRILL-2546
                 URL: https://issues.apache.org/jira/browse/DRILL-2546
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types, Execution - Relational Operators
            Reporter: Rahul Challapalli
            Assignee: Daniel Barclay (Drill)


git.commit.id.abbrev=f1b59ed

I attached 2 files which contains the same values. 

The below query is not doing an implicit cast between double and float
{code}
select count(*) from dfs.`cross-sources`.`fewtypes_null.parquet` p
. . . . . . . . . . . . . . > inner join dfs.`cross-sources`.`fewtypes_null.json` o
. . . . . . . . . . . . . . >     on p.float_col=o.float_col;
+------------+
|   EXPR$0   |
+------------+
| 1          |
+------------+
1 row selected (0.148 seconds)
{code}

However if we do an explicit cast, we get the right result
{code}
select count(*) from dfs.`cross-sources`.`fewtypes_null.parquet` p
. . . . . . . . . . . . . . > inner join dfs.`cross-sources`.`fewtypes_null.json` o
. . . . . . . . . . . . . . >     on p.float_col=cast(o.float_col as float);
+------------+
|   EXPR$0   |
+------------+
| 17         |
+------------+
{code}



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