drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1125) Implicit cast not working in the join condition
Date Wed, 09 Jul 2014 22:47:05 GMT
Rahul Challapalli created DRILL-1125:
----------------------------------------

             Summary: Implicit cast not working in the join condition
                 Key: DRILL-1125
                 URL: https://issues.apache.org/jira/browse/DRILL-1125
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types, Query Planning & Optimization
            Reporter: Rahul Challapalli
         Attachments: donuts.json, prices.json

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;




--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message