[
https://issues.apache.org/jira/browse/IMPALA-13494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17896488#comment-17896488
]
ASF subversion and git services commented on IMPALA-13494:
----------------------------------------------------------
Commit dea4e99be6ffad5e04148050c19a3b1e60cd2ffd in impala's branch
refs/heads/master from Steve Carlin
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=dea4e99be ]
IMPALA-13494: Calcite planner group_concat with distinct failing
The following query is failing.
select sum(len_orderkey), sum(len_comment)
from (
select
length(group_concat(distinct cast(l_orderkey as string))) len_orderkey,
length(group_concat(distinct(l_comment))) len_comment
from tpch.lineitem
group by l_comment
) v
There is code where in AggregationFunction for group_concat that calls
to ignore an implicit cast. The 'isImplicitCast_' member is being used
directly in this function, but the variable is overridden in the
isImplicitCast method for the Calcite planner. A small change was needed
to call the isImplicitCast() function rather than use the member variable.
Change-Id: Idec41597b40a533bc0774b4ff2ab5059c7f324e2
Reviewed-on: http://gerrit.cloudera.org:8080/22025
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> Calcite planner: group_concat failing with distinct
> ---------------------------------------------------
>
> Key: IMPALA-13494
> URL: https://issues.apache.org/jira/browse/IMPALA-13494
> Project: IMPALA
> Issue Type: Sub-task
> Affects Versions: Impala 4.5.0
> Reporter: Steve Carlin
> Priority: Major
> Fix For: Impala 4.5.0
>
>
> The following query is failing in distinct.test
>
> select sum(len_orderkey), sum(len_comment)
> from (
> select
> length(group_concat(distinct cast(l_orderkey as string)))
> len_orderkey,
> length(group_concat(distinct(l_comment))) len_comment
> from tpch.lineitem
> group by l_comment
> ) v
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
