[
https://issues.apache.org/jira/browse/IMPALA-10104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
lxc updated IMPALA-10104:
-------------------------
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.:
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 ?? ()
was:
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 ?? ()
> 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
