[jira] [Resolved] (IMPALA-11061) Multi-aggregation functions cause a crash

["Pain Sun (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-11061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pain Sun resolved IMPALA-11061.
-------------------------------
    Fix Version/s: Impala 4.0.0
       Resolution: Resolved

> Multi-aggregation functions cause a crash
> -----------------------------------------
>
>                 Key: IMPALA-11061
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11061
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 3.4.0
>         Environment: centos
>            Reporter: Pain Sun
>            Priority: Major
>             Fix For: Impala 4.0.0
>
>   Original Estimate: 168h
>  Remaining Estimate: 168h
>
> A query with multi-aggregation functions cause a crash.I update the version to 3.4.0 and update the code as IMPALA-9809 and compiled.But still cause the bug.
> Log:
> {code:java}
> // code placeholder
> A fatal error has been detected by the Java Runtime Environment:
> #
>  SIGSEGV (0xb) at pc=0x000000000152e2d8, pid=6301, tid=0x00007f5c425a1700
> #
> JRE version: Java(TM) SE Runtime Environment (8.0_202-b08) (build 1.8.0_202-b08)
> Java VM: Java HotSpot(TM) 64-Bit Server VM (25.202-b08 mixed mode linux-amd64 compressed oops)
> Problematic frame:
> C  [impalad+0x112e2d8]  impala::AggFnEvaluator::SerializeOrFinalize(impala::Tuple*, impala::SlotDescriptor const&, impala::Tuple*, void*)+0x48
> #
> Core dump written. Default location: /var/lib/impala/core or core.6301
> #
> An error report file with more information is saved as:
> /var/lib/impala/hs_err_pid6301.log
> #
> If you would like to submit a bug report, please visit:
>   http://bugreport.java.com/bugreport/crash.jsp
>  {code}
> Sql:
> {code:java}
> // code placeholder
>   select
>     cast(types AS string) AS types,
>     bn,
>     max(mb) as mb
> from
>     (
>         select
>             case
>                 when sn in('a') then '2'
>             end as types,
>             bn,
>             sn,
>             tid,
>             max(m1) as m1,
>             max(rm) as mb,
>             max(day) as day,
>             max(tpm) as tpm,
>             sum(if(rf is null, 0, rf)) as rf,
>             sum(num) as num,
>             max(
>                 tpm - if(rf is null, 0, rf)
>             ) as mtpmr,
>             count(if(rf is not null, oid, null)) as rc,
>             min(created) as min_created,
>             max(created) as max_created,
>             min(paytime) as min_paytime,
>             max(paytime) as max_paytime
>         from
>             td.tdn
>         where
>             mainsn = 'a'
>             and bn != ''
>             and sn in('a')
>         group by
>             sn,
>             bn,
>             tid
>     ) as allresult
> group by
>     bn,
>     types,
> having
>     ((sum(tpm) = 687.15))
>     and (((sum(tpm) - sum(rf)) = 687.15))
>     and ((count(distinct(day)) = 3))
>     and ((count(distinct(tid)) = 3))
>     and ((sum(num) = 9))
>     and ((sum(rf) = 0))
>     and ((sum(rc) = 0))
>     and (
>         (
>             min(min_created) >= '2021-11-02 00:00:00'
>             and min(min_created) <= '2021-11-02 23:00:00'
>         )
>     )
>     and (
>         (
>             (sum(tpm) / count(distinct(day))) >= 229.05
>         )
>     ){code}
>  
> if I query  `max(mb) as mb` with having clause ,will crash.
> if I delete one of these two,will not crash.
> it seems like IMPALA-9809  but I have already fix it ,still cause crash.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)