Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Not A Bug
-
None
-
None
-
None
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.