Rahul Challapalli created DRILL-2549:
----------------------------------------

             Summary: Implicit Cast between integer and varchar columns in a 
join should work
                 Key: DRILL-2549
                 URL: https://issues.apache.org/jira/browse/DRILL-2549
             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 contain the same values

The below query is not doing an implicit cast between a varchar and an integer
{code}
select count(*) from dfs.`cross-sources`.`fewtypes_null.parquet` p
inner join dfs.`cross-sources`.`fewtypes_null.tbl` o
    on p.int_col=o.columns[0];
Query failed: RemoteRpcException: Failure while running fragment., Failure 
finding function that runtime code generation expected.  Signature: 
compare_to_nulls_high( INT:OPTIONAL, VARCHAR:OPTIONAL ) returns INT:REQUIRED [ 
08df7d57-c436-4ff8-9a31-48368ba05531 on qa-node190.qa.lab:31010 ]
[ 08df7d57-c436-4ff8-9a31-48368ba05531 on qa-node190.qa.lab:31010 ]
{code}



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

Reply via email to