[DRILL-1125] Implicit cast not working in the join condition

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.6.0
• Component/s: Execution - Data Types, Query Planning & Optimization
• Assignee: DrillCommitter
• Reporter: Rahul Kumar Challapalli
• Due: 22/Aug/14
• Created: 09/Jul/14 22:46
• Updated: 01/Oct/14 23:39
• Resolved: 01/Oct/14 23:39

Description

git.commit.id.abbrev=810a204
Build # 26322

In the below query there is no type attached to 'donuts.id' but we expect implicit cast to work in this case. Data files referenced are also attached

create view v1 as select cast(id as int) a, cast(price as double) b from prices;
select v1.a from v1 inner join donuts on v1.a = donuts.id;

Error From Sqlline : UnsupportedOperationException:[ Failure finding function that runtime code generation expected. Signature: compare_to( INT:OPTIONALVARCHAR:OPTIONAL, ) returns INT:REQUIRED ]

With slight modification the below query works

select v1.a from v1 inner join donuts on v1.a = donuts.id + 1 -1;

Issue Links

• duplicates: DRILL-1447 Hash join implicit cast fails
• is duplicated by: DRILL-1447 Hash join implicit cast fails