[IMPALA-13476] Calcite Planner: IMPALA-1519 query throws exception

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Epic Color: ghx-label-11
• Assignee: Unassigned
• Reporter: Steve Carlin
• Created: 24/Oct/24 13:19
• Updated: 24/Oct/24 13:23

Description

The following query in analytics-fn.test does not work in CalcitePlanner:

1. IMPALA-1519: Check that the first analytic sort of a select block

1. materializes TupleIsNullPredicates to be substituted in ancestor nodes.

select

  sum(t1.id) over (partition by t1.bool_col),

  count(1) over (order by t1.int_col),

  avg(g) over (order by f),

  t2.a,

  t2.d

from alltypestiny t1

left outer join

  (select

     id as a,

     coalesce(id, 10) as b,

     int_col as c,

     coalesce(int_col, 20) as d,

     bigint_col e,

     coalesce(bigint_col, 30) as f,

     coalesce(id + bigint_col, 40) as g

   from alltypestiny) t2

on (t1.id = t2.a + 100)