[
https://issues.apache.org/jira/browse/IMPALA-13476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin resolved IMPALA-13476.
-----------------------------------
Resolution: Fixed
> Calcite Planner: IMPALA-1519 query throws exception
> ---------------------------------------------------
>
> Key: IMPALA-13476
> URL: https://issues.apache.org/jira/browse/IMPALA-13476
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Steve Carlin
> Assignee: Steve Carlin
> Priority: Major
> Attachments: joinfix.diff
>
>
> The following query in analytics-fn.test does not work in CalcitePlanner:
> # IMPALA-1519: Check that the first analytic sort of a select block
> # 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)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
