[IMPALA-3058] Runtime filter src and target exprs not always same type

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.5.0
• Fix Version/s: Impala 2.5.0
• Component/s: Distributed Exec
• Labels: runtime-filters
• Target Version: Impala 2.5.0
• Assignee: Dimitris Tsirogiannis
• Reporter: Henry Robinson
• Created: 23/Feb/16 06:17
• Updated: 24/Feb/16 02:33
• Resolved: 24/Feb/16 02:33

Description

In TPC-DS Q59, look at the highlighted predicate below:

  where
    d.d_week_seq = wss.d_week_seq
    and ss_store_sk = s_store_sk
    and d_month_seq between 1185 + 12 and 1185 + 23
  ) x
where
  s_store_id1 = s_store_id2
  and d_week_seq1 = d_week_seq2 - 52 ######### <------
order by
  s_store_name1,
  s_store_id1,

The source side generates an expr of type BIGINT. The target expr has type INT. The filter produced is not compatible with the target side, and the query gives incorrect results. The frontend needs to ensure that filter expressions are exactly type compatible.