[
https://issues.apache.org/jira/browse/IMPALA-10104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17184153#comment-17184153
]
Tim Armstrong commented on IMPALA-10104:
----------------------------------------
This is most likely IMPALA-8969, which was still present in CDH6.3.1
I couldn't reproduce on master with a similar query.
{noformat}
SELECT max(date_string_col) as datekey ,
if(`string_col` like '%a','A',
if(`string_col` like '%b', 'B',
if(`string_col` like '%c', 'C',
if(`string_col` like '%d', 'D', 'E')))) test,
sum(cast(double_col AS FLOAT)) / (id/ 1000) AS ecpm,
id AS e_num,
count(DISTINCT timestamp_col) AS r_num,
sum(float_col) AS d_num,
sum(double_col) AS c_num,
count(DISTINCT tinyint_col) AS uv,
sum(bigint_col) /count(DISTINCT bigint_col) AS d_rate,
sum(int_col) /count(DISTINCT int_col) AS c_rate,
sum(cast(double_col AS FLOAT)) AS money
FROM alltypes
WHERE date_string_col = '01/13/09'
GROUP BY 2, 4;
{noformat}
> 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.:
>
> Program terminated with signal 6, Aborted.
> #0 0x00007f5498deb1f7 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-8.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 0x00007f5498deb1f7 in raise () from /lib64/libc.so.6
> #1 0x00007f5498dec8e8 in abort () from /lib64/libc.so.6
> #2 0x00007f549bd7d3b5 in os::abort(bool) () from
> /opt/jdk/jre/lib/amd64/server/libjvm.so
> #3 0x00007f549bf1f673 in VMError::report_and_die() () from
> /opt/jdk/jre/lib/amd64/server/libjvm.so
> #4 0x00007f549bd828bf in JVM_handle_linux_signal () from
> /opt/jdk/jre/lib/amd64/server/libjvm.so
> #5 0x00007f549bd78e13 in signalHandler(int, siginfo*, void*) () from
> /opt/jdk/jre/lib/amd64/server/libjvm.so
> #6 <signal handler called>
> #7 0x00000000011084ff in impala_udf::FunctionContext::Free(unsigned char*) ()
> #8 0x0000000000b92d3f in
> impala::AggregateFunctions::StringValSerializeOrFinalize(impala_udf::FunctionContext*,
> impala_udf::StringVal const&) ()
> #9 0x00000000013207ed in
> impala::AggFnEvaluator::SerializeOrFinalize(impala::Tuple*,
> impala::SlotDescriptor const&, impala::Tuple*, void*) ()
> #10 0x00007f54321eb82f in ?? ()
> #11 0x00007f535bf19e00 in ?? ()
> #12 0x0000000000000003 in ?? ()
> #13 0x00000400e360a8c5 in ?? ()
> #14 0x0000000000000001 in ?? ()
> #15 0x00007f4fd302f1e0 in ?? ()
> #16 0x00000000435d70c0 in ?? ()
> #17 0x00007f535bf19f00 in ?? ()
> #18 0x00007f532b536000 in ?? ()
> #19 0x0000000012effc08 in ?? ()
> #20 0x000000001e39d5d0 in ?? ()
> #21 0x0000000000000400 in ?? ()
> #22 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
