[DRILL-5001] Join only supports implicit casts error even when I have explicit cast

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Component/s: Query Planning & Optimization
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 04/Nov/16 06:46
• Updated: 22/Mar/17 23:47
• Resolved: 22/Mar/17 23:46

Description

git.commit.id.abbrev=190d5d4

The below query fails even when I had an explicit cast on the right hand side of the join condition. The data also contains a metadata cache

select
  a.int_col,
  b.date_col 
from
  dfs. `/ drill / testdata / parquet_date / metadata_cache / mixed / fewtypes_null_large ` a 
  inner join
    (
      select
        * 
      from
        dfs. `/ drill / testdata / parquet_date / metadata_cache / mixed / fewtypes_null_large ` 
      where
        dir0 = '1.2' 
        and date_col > '1996-03-07' 
    )
    b 
    on a.date_col = cast(date_add(b.date_col, 5) as date) 
where
  a.int_col = 7 
  and a.dir0 = '1.9' 
group by
  a.int_col,
  b.date_col;

Error: SYSTEM ERROR: DrillRuntimeException: Join only supports implicit casts between 1. Numeric data
 2. Varchar, Varbinary data 3. Date, Timestamp data Left type: DATE, Right type: VARCHAR. Add explicit casts to avoid this error

Fragment 2:0

[Error Id: a1b26420-af35-4892-9a87-d9b04e4423dc on qa-node190.qa.lab:31010] (state=,code=0)

I attached the data and the log file.