You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Zoltán Borók-Nagy (Jira)" <ji...@apache.org> on 2021/05/31 11:52:00 UTC
[jira] [Commented] (IMPALA-10104) multiple if funtion and
multiple-agg cause impalad crashed
[ https://issues.apache.org/jira/browse/IMPALA-10104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17354424#comment-17354424 ]
Zoltán Borók-Nagy commented on IMPALA-10104:
--------------------------------------------
Seems like IMPALA-8969 or IMPALA-9809. Could you please try again with those fixes?
> multiple if funtion and multiple-agg cause impalad crashed
> -----------------------------------------------------------
>
> Key: IMPALA-10104
> URL: https://issues.apache.org/jira/browse/IMPALA-10104
> Project: IMPALA
> Issue Type: Bug
> Components: Backend, Frontend
> Affects Versions: Impala 3.2.0
> Environment: CDH6.3.1
> jdk 1.8.0_131
> Reporter: lxc
> Priority: Major
>
> sql:
> SELECT max(datekey) as datekey ,
> if(`exp` like '%a','A',
> if(`exp` like '%b', 'B',
> if(`exp` like '%c', 'C',
> if(`exp` like '%d', 'D', 'E')))) test,
> sum(cast(money AS FLOAT)) / (count(*)/ 1000) AS ecpm,
> count(*) AS e_num,
> count(DISTINCT aa) AS r_num,
> sum(isd) AS d_num,
> sum(isc) AS c_num,
> count(DISTINCT bb) AS uv,
> sum(isd) /count(DISTINCT aa) AS d_rate,
> sum(isc) /count(DISTINCT aa) AS c_rate,
> sum(cast(money AS FLOAT)) AS money
> FROM tableA
> WHERE datekey = '20200812'
> GROUP BY test;
> the coredump info.:
>
> minicoredump:
> #0 0x00007f1005f491f7 in raise () from /lib64/libc.so.6
> Missing separate debuginfos, use: debuginfo-install cyrus-sasl-gssapi-2.1.26-23.el7.x86_64 cyrus-sasl-lib-2.1.26-23.el7.x86_64 cyrus-sasl-plain-2.1.26-23.el7.x86_64 glibc-2.17-196.el7.x86_64 keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.15.1-46.el7.x86_64 libcom_err-1.42.9-10.el7.x86_64 libdb-5.3.21-20.el7.x86_64 libselinux-2.5-11.el7.x86_64 nss-softokn-freebl-3.28.3-6.el7.x86_64 openssl-libs-1.0.2k-8.el7.x86_64 pcre-8.32-17.el7.x86_64 zlib-1.2.7-17.el7.x86_64
> (gdb) bt
> #0 0x00007f1005f491f7 in raise () from /lib64/libc.so.6
> #1 0x00007f1005f4a8e8 in abort () from /lib64/libc.so.6
> #2 0x00000000048d4ca4 in google::DumpStackTraceAndExit() ()
> #3 0x00000000048cb6fd in google::LogMessage::Fail() ()
> #4 0x00000000048ccfa2 in google::LogMessage::SendToLog() ()
> #5 0x00000000048cb0d7 in google::LogMessage::Flush() ()
> #6 0x00000000048ce69e in google::LogMessageFatal::~LogMessageFatal() ()
> #7 0x000000000281201b in impala::FreePool::CheckValidAllocation(impala::FreePool::FreeListNode*, unsigned char*) const ()
> #8 0x0000000002811cbd in impala::FreePool::Free(unsigned char*) ()
> #9 0x00000000028104c3 in impala_udf::FunctionContext::Free(unsigned char*) ()
> #10 0x00000000024c8ee6 in impala::AggregateFunctions::StringValSerializeOrFinalize(impala_udf::FunctionContext*, impala_udf::StringVal const&) ()
> #11 0x00000000024c410c in impala::AggFnEvaluator::SerializeOrFinalize(impala::Tuple*, impala::SlotDescriptor const&, impala::Tuple*, void*) ()
> #12 0x00007f0f008d88d5 in ?? ()
> #13 0x000000001c4e8790 in ?? ()
> #14 0x4fcef6b724afe578 in ?? ()
> #15 0x0000000000000000 in ?? ()
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org