[IMPALA-10104] multiple if funtion and multiple-agg cause impalad crashed

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 3.2.0
• Component/s: Backend, Frontend
• Environment: CDH6.3.1 ; jdk 1.8.0_131
• Flags: Important
• Epic Color: ghx-label-6
• Assignee: Unassigned
• Reporter: lxc
• Created: 25/Aug/20 07:33
• Updated: 31/May/21 11:51

Description

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 ?? ()

 

 

Issue Links

• relates to: IMPALA-8969 Grouping aggregator can cause segmentation fault when doing multiple aggregations.