[DRILL-2549] Implicit Cast between integer and varchar columns in a join should work

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Execution - Relational Operators
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 24/Mar/15 23:43
• Updated: 01/Oct/15 16:37

Description

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

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 ]