[ 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-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org